Had a requirement the other day to be able to visualize historical sales and forecasts in one continuous line chart. Actually pretty simple in Excel. And when you are working with a PowerPivot model and have the power of DAX at your disposal, it's even easier.
