Displaying zero values as gap in a chart

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

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
 
"" 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
 
Back
Top