• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 482
  • Last Modified:

Hide zero values on an X Y scatter graph

I have a dynamic XY chart.

Dates in COL A  and the values are in whatever column I offset to.   Some values are Zero.  I do not want to show the value on the chart as zero if there is no value.

I have tried using a custom # format.
I have tried using a formula  (probably didn't do this one correct)

How can I do this.  I want to show the gap in the line not have it drawn on the X axis as Zero.

thanks experts.

1 Solution
skillileaAuthor Commented:
Think I found a possible one.

IF(A1 = 0 , #N/A, A1)

any better ways so I don't have to add another IF in my formula.

Rory ArchibaldCommented:
Not really - the only guaranteed solution is a truly blank cell. Using NA() will give you an interpolated value if it's in the middle of your data, whereas a blank cell will give a break in your line. It depends what you actually want plotted.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now