Excel Problems(Charts)

  • Thread starter Thread starter Shaijuzacharia
  • Start date Start date
S

Shaijuzacharia

I was trying to make charts for values bieng calculated using
formulae. How can I prevent excel from taking values as Zero if no
value is given in the cells where primary data is given.
 
Select your chart, then Tools/ Options/ Chart/ Plot empy cells as:
and choose Not plotted, or Interpolated, not Zeroes.

If the cell isn't empty, but the result of a formula returning "", for
example, then replace the "" in the formula by NA()
 
Back
Top