Zero Values in Chart
 

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

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(A10,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