As an alternative to Jon's idea:
In the cell where you have no data enter =NA(). These will display as #N/A
You category axis will show all the months of the year
As new data becomes available, overtype the N/A in the cell.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Brisbane Rob"
wrote in message
news:Brisbane.Rob.1vu3ua_1127516708.2377@excelforu m-nospam.com...
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