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
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
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
"Carol" <[email protected]> wrote in message
news:[email protected]...
> 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, thanks that worked like a charm! Kudos.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks