LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Brisbane Rob
 
Posts: n/a
Default Charting a full year without zeros


Help! I want to chart results for the coming year where the data feeds
in month-by-month. The problem is that the chart pluges to zero for the
future months. How do I terminate the data at the current point (January
to September) without having to reset the data ranges every month?

Thanks


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=470385

 
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
Auto Year scale John Sawyer Charts and Charting in Excel 1 July 19th 05 03:18 AM
Charting with zeros or DIV/0 values MarianneR Charts and Charting in Excel 1 July 9th 05 12:40 AM
How do I force leading zeros in an Excel cell? EricKei Excel Discussion (Misc queries) 2 June 15th 05 08:28 PM
How to compare current year to prior year in bar chart? substring Charts and Charting in Excel 4 May 12th 05 07:04 PM
Calculating commission schedule (will pay for help!) bootsy Excel Worksheet Functions 2 October 28th 04 07:24 AM


All times are GMT +1. The time now is 01:21 AM.

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

About Us

"It's about Microsoft Excel"