Hiding 0 values on graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dom - 15 Apr 2008 12:45 GMT

Hi

I am creating a graph to show information from this year I currently have it
set up so the graph shows jan-dec one line for 2007 and one line for 2008 the
information automatically populates itself into the chart so currently for
April 2008 to December 2008 the information is showing as zero and so there
is a big line that goes across zero on my graph. Is there anyway for the
graph to ignore the 0's? and only show any numbers above this?

Thank you

Reply to this Message

Jon Peltier - 16 Apr 2008 01:28 GMT

You could make a dynamic chart that plots an expanding range:

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

If you want to include the full year on the axis, don't make a dynamic range
for X values, only for Y values.

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

> Hi
>
[quoted text clipped - 9 lines]
>
> Thank you

Reply to this Message