Hi,

Regarding the =NA() comment: The use of this is mainly when one has a
formula that return a blank to one or more of the cells being plotted. You
generally don't just type =NA() in a cell in the data range, what you do is
modify a formula that might return "" so that it return NA when it would
return "", for example =IF(A1="",NA(),A1)

In these situations you don't use the Plot empty cells option, because it is
not even applicable. Meaning if the formula returns "" it is not consider
empty by Excel. The empty cell are cells that really have nothing in them.

Cheers,
Shane Devenshire

"Jack Tripper" wrote:

Excel has the option under
Tools - Options - Chart tab

Plot empty cells has
- Not plotted (leave gaps)
- Zero
- Interpoloated

i cannot find the option in Excel 2007, after hunting off and on for 3 hours.

Where is it?

i've already dismissed the hack of filling values with the formula
=NA()

References
http://support.microsoft.com/kb/302672
http://j-walk.com/ss/excel/usertips/tip024.htm
http://www.excelforum.com/excel-char...ng-values.html