Zero Values in Chart

[RUSS]

Can anyone please tell me how to stop a chart from displaying zero values.

EX: 10 x axis entries but only the first 5 contain non-zero values.

Thanks in advance.... Russ

[Jon Peltier]

If the cells are truly blanks, try Tools menu > Options > Chart tab >
Show blank cells as... Not Plotted.

If the cells only look like blanks, such as formulas that return "",
change the "" to NA():

=IF(A1>0,A1,NA())

The NA() produces an ugly #N/A error in the sheet, but in line and
scatter charts they aren't plotted. Debra Dalgleish shows how to hide
the errors with conditional formatting:

http://contextures.com/xlCondFormat03.html#Errors

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


RUSS wrote:

> Can anyone please tell me how to stop a chart from displaying zero values.
>
> EX: 10 x axis entries but only the first 5 contain non-zero values.
>
> Thanks in advance.... Russ
>
>