How do i keep cells with a formula returning "" from being plotted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a chart that referrences cells that contain an IF statement that
returns "". Although the chart option 'do not plot blank cells' is marked,
Excel graphs these cells as being 0.
 
Hi,

Instead of "" use NA()

Cheers
Andy
I have a chart that referrences cells that contain an IF statement that
returns "". Although the chart option 'do not plot blank cells' is marked,
Excel graphs these cells as being 0.
Click to expand...
 
unfortunately "" will plot as a zero
#NA will plot as interpolated with no symbol
if you do not want to be able to use the Do not plot at all aspect, what I
have done is make the cells I dont' want to plot be a uniques character,
copy the data select all paste special values somewhere else. use find
replace and relaplace the unique characer with nothing. Then plot this data.
 
You must log in or register to reply here.

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

Similar Threads

Surpressing plot of blank cells 3
Blank instead of "" 5
How do I disable "Plot visible cells only" when it is greyed out? 1
How do I not plot zero values that result from a formula in Excel? 1
How do I plot "" as empty rather than zero in a chart 1
Seemingly random plot area drift? 2
How do I leave out blank cells in a line graph? 1
How do I keep zero values from plotting in charts? 6

Back
Top