Do not want zero values to plot in a chart

[Guest]

If I have a chart -(line chart) for a spreadsheet and there are some cells that are zero as a result of a formula what can I do to not have those zero values plot on the chart? I have included the condition with the formula to have it display as a blank instead of a zero, but the value of the formual still plots

Thanks for any input

Michelle

 

[Frank Kabel]

Hi Michele
try the following in your formula:
=IF(A1=0,NA(),A1)
the #NA reult is not plotted in your chart. If you like you can hide
these errors with conditional formats

Frank

 

[Peter Atherton]

-----Original Message-----
If I have a chart -(line chart) for a spreadsheet and

there are some cells that are zero as a result of a
formula what can I do to not have those zero values plot
on the chart? I have included the condition with the
formula to have it display as a blank instead of a zero,
but the value of the formual still plots.

Thanks for any input.

Michelle
.

If therre is only one set of data it is easy.

Select the chart and choose Tools, Options, Cart and tick
the Plot Visible Cells Only radio button.

Then hide the column or rows with zero

Regards
Peter