View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.