XY chart not dropping off to 0, when there is not value

  • Thread starter Thread starter drjayr2002
  • Start date Start date
D

drjayr2002

I have a simple xy chart with months on the xxis. I am collecting data as
every month goes by. Is there a way to chart all 12 months on X axis and the
Y axis to show the plot only when it is non zero. (typically it drops off to
0, when there is not any data and have zero values). Thanks
 
If the formula produces "", it has the same effect, since "" is text, and
Excel assigns a numerical value of zero to text.

- Jon
 
I am having the same problem with a chart. I have tried having the formula
to produce both the "" and the NA, but I'm still getting the 0 in my chart.
Any other suggestions.

Anita
 
You don't want ""
You don't want NA as a text string.
You want NA(), the function, which you'll see as a #N/A result.
 
Back
Top