chart without "0" and blank

minharnold · Mar 21st, 2002, 09:19 PM

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 · Mar 21st, 2002, 09:35 PM

Try placing #N/A in your sheets2 data cell

Ivan

minharnold · Mar 22nd, 2002, 06:38 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 09:19 PM	#1
minharnold New Member Join Date: Mar 2002 Posts: 2	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

Mar 21st, 2002, 09:35 PM	#2
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Try placing #N/A in your sheets2 data cell Ivan

Mar 22nd, 2002, 06:38 PM	#3
minharnold New Member Join Date: Mar 2002 Posts: 2	Thanks for responding, Ivan. I cant do #N/A or other characters because those data cells also in calculations for other sheet.