Thread: 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

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/
_______


Brisbane Rob wrote:
> 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
>
>

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" <Brisbane.Rob.1vu3ua_1127516708.2377@excelforum-nospam.com>
wrote in message
news:Brisbane.Rob.1vu3ua_1127516708.2377@excelforum-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
>

Thanks - dynamic ranges sort out the problem

With my spreadsheet, I have the values for the chart being referenced from other cells. Having several months that have zero values (which cannot be deleted), how can I have a dynamic chart to not display the zero values?

Using =NA# causes the same issue and has the extra months plotted which I don't want. Is there a way to make a cell that is equal to another cell (which is zero) be blank/empty?

With my spreadsheet, I have the values for the chart being referenced from other cells. Having several months that have zero values (which cannot be deleted), how can I have a dynamic chart to not display the zero values?

The dynamic charts work if the zero values are actually BLANK values.

Using =NA# causes the same issue and has the extra months plotted which I don't want. Is there a way to make a cell that is equal to another cell (which is zero) be blank/empty?