LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many data series can i format Derek Charts and Charting in Excel 4 June 8th 06 05:29 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Dynamic series in Chart Jeff Charts and Charting in Excel 2 February 24th 05 11:54 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 12:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"