From: Ayo on
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
"" 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