Don't plot zeros in chart

[Tod]

The worksheet has a table of data and then a chart of
that data. Some of the rows in the data are zero. I don't
want the chart to plot those zeros. I know I can use #N/A
to accomplish this, but it looks ugly to the customer to
see #N/A in the data. Is there another way to easily NOT
chart the zeros. OR, is there a way to have the #N/A
display as a zero?

tod

 

[Sean Howard]

Dear Tod,

I would do one of the following (depending on the nature of the data),
either :-

A) Clear all the cells containing the #N/A. The chart will be the same,
and the user happy

B) Try conditional formatting on the source data. Use the formulae
=ISERROR(..) and format the Font colour to be white (or whatever
background colour your cells are in)

Option B) seems better as you will not have to change any actual cells,
but only their format


Sean

"Just press the off switch, and go to sleep!"