Yes. I have "#N/A" in the cells, but the chart is still interpolating them.
I want gaps. I thought if I could be sure that the switch was set to "Not
plotted" it may leave gaps. But I can't find that switch in Excel 2007.


"David Biddulph" wrote:

"Tushar Mehta" wrote in message
om...
In article ,
says...
Where is the option not to plot zero value on a chart hiding in Excel
2007?

Is there such an option? In previous versions, the solution was to
replace
the zero with a truly empty cell or, if the result of a formula, NA().

Perhaps what the OP was thinking of in earlier versions was:
Tools/ Options/ Chart/ Plot empty cells as ...
The options a
Not plotted (leave gaps), or
Zero, or
Interpolated

Empty cells are of course different from zeroes, but that may be where the
confusion arises?
--
David Biddulph