minharnold
New Member
- Joined
- Mar 20, 2002
- Messages
- 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
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