Don't plot zeros in chart
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
|