Hiding Zero Values on Chart
 

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?

Hiding Zero Values on Chart
 

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?

Hiding Zero Values on Chart
 

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?

Hiding Zero Values on Chart
 

No, it's not that easy nor is it dynamic. You could hide the entire
stretches where there are only zeros, since by default hidden cells are not
plotted.

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


"kippers" wrote in message
...
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?