Jon,
Thanks for the advice- they are simply zero values with no formula attached.
However, there are a lot of elements (series) (20-30) so when the graph is
generated it has large gaps where zero values exist. I was wonderign if there
was a way in which elements or series that have a zero value could be
eliminated fromt he graph itself (i.e. the actual series header on the grpah
would not even appear and teh graph would show only those series with a value
0?)
Cheers,
Paul
"Jon Peltier" wrote:
Are they zero values, or formulas that return zero? If they are zeros,
delete the zeros. If they are formulas, change the formula from
=A1
to
=IF(A1="",NA(),A1)
NA() leaves an error in the cell (#N/A) but doesn't appear on a line or XY
chart. You can use conditional formatting to hide the error.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"kippers" wrote in message
...
Is it possible to automatically 'ignore' zero values when plotting a
chart.
i.e. any data set with a value of zero would simply not be displayed on
the
chart?