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.
 

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

xy scatter - dates off 4
XY Charts 1
How to chart months by financial year 0
time scale proportional using a column chart - not just for scatte 4
secondary category axis reset to min=0 max=0 on save 1
XY Chart - Vertical Axis Crosses - Cell reference vs. Value 1
XY Charts Excluding Weekends 1
How do I adjust marker spacing in Excel scatter plot? 1

Back
Top