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
|
|||
|
|||
Displaying zero values as gap in a chart
I am looking for a way to display zero values in my charts as gaps. Right
now I there is a big slant in my chart that I am trying to get rid of. The range I am using has formular in them, so even when the cells evaluate to blanks, they are displayed as zeros on the chart. Any help will be greatly apprecaited. Thanks |
#2
|
|||
|
|||
Displaying zero values as gap in a chart
"" is not a blank, it is a short text value. Excel evaluates text as zero.
In the formula, replace "" by NA(), which places #N/A into the cell. A line chart or XY chart will not plot a point where the value is #N/A. If there are points on each side of the #N/A, these points will be connected by the line. If the series ends with one or more #N/A, there will not be a line to the end of the chart. There is no way for a formula to return a true blank. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Ayo wrote: I am looking for a way to display zero values in my charts as gaps. Right now I there is a big slant in my chart that I am trying to get rid of. The range I am using has formular in them, so even when the cells evaluate to blanks, they are displayed as zeros on the chart. Any help will be greatly apprecaited. Thanks |
Thread Tools | |
Display Modes | |
|
|