Charting a full year without zeros

[Brisbane Rob]

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

 

[Jon Peltier]

Rob -

Set up a dynamic chart, using dynamic ranges that count the number of
values and resize to thatnumber. Examples and links:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Bernard Liengme]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[Brisbane Rob]

Thanks - dynamic ranges sort out the problem