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()
--
David Biddulph

wrote in message
...
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.