View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Tom Ulincy Tom Ulincy is offline
external usenet poster
 
Posts: 1
Default Dynamic data series

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