If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
zero values in charts
Sounds like lots of people have trouble with zero values
in charts. My problem is that I am plotting line charts from data where there are empty cells. These cells plot as zero even when I specify under chart options to not plot empty cells. Sounds like a glitch in the programming. Any suggestions? I tried changing the cells to N/a, and changing the cell formatting, but to no avail. |
#2
|
|||
|
|||
zero values in charts
If they plot as zero, the cells are not empty. Most likely, they
contain an IF() formula that is returning "". If it returns #N/A or equivaletly NA() instead of "", the graph line will will connect directly from the previous to the next point as though the cell conaining #N/A did not exist. Jerry Patty wrote: Sounds like lots of people have trouble with zero values in charts. My problem is that I am plotting line charts from data where there are empty cells. These cells plot as zero even when I specify under chart options to not plot empty cells. Sounds like a glitch in the programming. Any suggestions? I tried changing the cells to N/a, and changing the cell formatting, but to no avail. |
#3
|
|||
|
|||
zero values in charts
You can also try telling it to interpolate the data
(ToolsOptionsChart) -----Original Message----- Sounds like lots of people have trouble with zero values in charts. My problem is that I am plotting line charts from data where there are empty cells. These cells plot as zero even when I specify under chart options to not plot empty cells. Sounds like a glitch in the programming. Any suggestions? I tried changing the cells to N/a, and changing the cell formatting, but to no avail. . |
#4
|
|||
|
|||
zero values in charts
Heather -
This will only work if the cells are really blank, unfortunately, not if they have formulas that look blank. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ heather p. wrote: You can also try telling it to interpolate the data (ToolsOptionsChart) -----Original Message----- Sounds like lots of people have trouble with zero values in charts. My problem is that I am plotting line charts from data where there are empty cells. These cells plot as zero even when I specify under chart options to not plot empty cells. Sounds like a glitch in the programming. Any suggestions? I tried changing the cells to N/a, and changing the cell formatting, but to no avail. . |
#5
|
|||
|
|||
zero values in charts
Thanks all for the help--indeed, when I clear the cells
their corresponding "zero" datapoints disappear from the graph! Not sure what was in the cells, though--probably some copied weirdness from my Access database. -----Original Message----- If they plot as zero, the cells are not empty. Most likely, they contain an IF() formula that is returning "". If it returns #N/A or equivaletly NA() instead of "", the graph line will will connect directly from the previous to the next point as though the cell conaining #N/A did not exist. Jerry Patty wrote: Sounds like lots of people have trouble with zero values in charts. My problem is that I am plotting line charts from data where there are empty cells. These cells plot as zero even when I specify under chart options to not plot empty cells. Sounds like a glitch in the programming. Any suggestions? I tried changing the cells to N/a, and changing the cell formatting, but to no avail. . |
Thread Tools | |
Display Modes | |
|
|