Software

Ask something
Discussion Locked

Graphs in Excel

0 helpful
3 replies

by farellan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When a formula in a graph data range evaluates to a blank cell (i.e. ""), Excel takes it as a cero value. The line (or the bar) in the graph will show a zero value (and touch the x axis).
Is there a way to avoid this?
I want to use formulas in thedata range. In this way, the graph shows a line (or a bar) if data is available. If not, I want it to show nothing.
Thank you.

3 replies

by dklippert

In all versions of Excel, you can enter =NA()in the empty cell.
Excel will then interpolate the missing value and make a smooth line.
If you have Excel 2000 or 2002, go to Tools>Options and pick the Chart tab. You can have the chart treat blank cells as "Not plotted" (leave gaps), Zero (go down to the baseline), or Interpolated.

This discussion is closed to new replies.