Displaying zero values as gap in a chart
in [Charts]
|
Prev: Dynamically Scale X Axis on Column Chart Based on Number of Catego
Next: Excel graphs change when pasted into Publisher - Metafiles change?
From: Ayo on 31 Jan 2010 19:59 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
From: Jon Peltier on 31 Jan 2010 22:59
"" 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 |