Omitting Zeros in a chart
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
On Sep 2, 6:43*pm, spudsnruf
wrote:
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.
|