Omitting Zeros in a chart

  • Thread starter Thread starter spudsnruf
  • Start date Start date
S

spudsnruf

Hello, I have a simple line chart, generated from a list of numbers, many of
the numbers are zero, which I dont wnat to show up on the chart. At the
moment, they show up as a point on the bottom of the horizontal axis. How do
I make sure they dont show if zero please? Thank you.
 
Replace them with blanks if they are just numbers. If they are
returned from a formula, you could do this:

=IF(your_formula=0,NA(),your_formula)

This will return an error instead of zero (which can be hidden using
conditional formatting if you don't want to see them), and errors will
not show on your chart.

Hope this helps.

Pete
 
To make a chart skip a point, and not count it as zero, have it reutrn the
#N/A value. In formual form, this would be:
=If(A2=0,NA(),A2)
 
Back
Top