Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
During a year I have actual data for part of the year (e.g. Jan to May) and
forecast data for the balance of the year (e.g. June to Dec). I am showing the data on a line chart. I know how to associate a dynamic range name to have the actual data series increment each month. My question is, how can I graph the forecast data from Jun to Dec only? If I change the length of the forecast series to 7 periods (i.e. Jun to Dec) the data are plotted in the wrong months (i.e. Jan to July). Thanks for your help. Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How many data series can i format | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Dynamic series in Chart | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |