How do I stop zeros from plotting in Excel 2003 Chart

R

rjett

I have data that plots as zeros. This clutters up any trend analysis.
Without manually removing all zero (x,y) plots, I want to not see them.
 
A

Andy Pope

Hi,

If the data is the result of a formula then try using NA() instead of ""
Something along the lines of

=IF(ISNUMBER(A1),A1,NA())

If not then I think more detail of your data is needed in order to
understand why it plots *AS* zero.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non Linear Scatter plot, need to find y value 3
Scatter chart with categories on x-Axis 2
Data points in chart incorrect 0
How do I disable "Plot visible cells only" when it is greyed out? 1
Surpressing plot of blank cells 4
x-y scatter plots and trend lines 0
Chart Plot Area changes in Excel 2007 0
Employee Schedule not plotting properly - chart type / data series not correct 0

Top