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.



Jon Peltier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question