Can time series be plotted as half solid, half dotted line?

[Guest]

Is there a way to plot a single time series as a half solid line for actual
data and half dotted (or dashed) line for the forecast period? Thanks !

~Carol

 

[Bernie Deitrick]

Carol,

Break up your table into 3 columns, like this:

Date Actual Forecast
Date1 Actual1
Date2 Actual2
Date3 Actual3
Date4 Actual4
Date5 Actual5 Actual5
Date6 Forecast1
Date7 Forecast2
Date8 Forecast3
Date9 Forecast4
Date10 Forecast5

Then you will have two lines to graph - and one can be set to solid, the other dashed, and they will
meet at Date5, which should be the current date....

HTH,
Bernie
MS Excel MVP

 

[Guest]

Bernie, thanks that worked like a charm! Kudos.