chart without "0" and blank

[minharnold]

hello,
I have difficulty doing lines chart without graphing "0" or "blank" in the graph with MS Office 2000. I am wondering if anyone here know how, I am very grateful.
Here is the problem:
10 cells directly to graph are in sheet1, and those 10 cells data are reference to 10 cells in sheet2. If I enter values in any of 10 cells in sheet2 that sheet1 references to, it will shown identical values in sheet1 otherwise it shows blank(s)
For test purposes, I entered values in that 9 cells and leave one cell blank in sheet2, sheet1 shown the same and the graph graph the data in sheet1 treats the blank cell as "0" value.
I have tried CHART/plot empty cells as 'not plotted' and 'interpolated' but the graph still graph it as "0".
Anyone know the way around this, im greatly appreciated.
minharnold@yahoo.com

 

[Ivan F Moala]

Try placing #N/A in your sheets2 data cell


Ivan

 

[minharnold]

Thanks for responding, Ivan. I cant do #N/A or other characters because those data cells also in calculations for other sheet.