Software

Ask something
Discussion Locked

MS Excel Chart Plotting Blank Cell Prob'

0 helpful
3 replies

by laurie j

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

I have a spreadsheet that I want to plot a sctter graph against. The problem is that if a cell has a fomula in it that returns a blank cell e.g.=IF(F2=TRUE,E2,"") and I chart on this this cell is plotted as 0 (Zero) on the X Axis of the chart. Isthere anything I can use other than "" in the fomulae?

How do I stop these blank cells (even though they have a fomulae in) from plotting on the chart. I ahve tried looking in Tools, Options, Chart and nothing in there seems to effect this.

Iloom forward to hearing from anyone on this.

3 replies

by robert anderson

Laurie,

Replace the "" part of the formula with NA() this will replace the blank spaces with the error value #NA these will not be plotted on the chart.

This discussion is closed to new replies.