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

[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

 

[David Biddulph]

If you have a formula producing zero, replace the zero by NA().

 

[Jon Peltier]

If the formula produces "", it has the same effect, since "" is text, and
Excel assigns a numerical value of zero to text.

- Jon

 

[AWalker]

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

 

[David Biddulph]

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.