Diagram show blank as zero value when based on a formula

G

Guest

When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart
will show the blank value "" as zero even if you whant to plot gaps or plot
the empty cell interpolated. Yes, I know Excel say empty cell and the cell is
not empty when there is a formula. Is there anybody who have found a "work
around"? I often have formulas that generate zero in the result but I want to
plot the result as if it was empty.
 
G

Guest

I found the reply myself in a question from another user similar to this issue.

I will use NA() instead of ""

Thank you that works!
 
D

David Biddulph

Data_Lisa said:
When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart
will show the blank value "" as zero even if you whant to plot gaps or
plot
the empty cell interpolated. Yes, I know Excel say empty cell and the cell
is
not empty when there is a formula. Is there anybody who have found a "work
around"? I often have formulas that generate zero in the result but I want
to
plot the result as if it was empty.
Click to expand...

Replace the blank "" by NA()
 
G

Guest

Yes, but I can't have the line to leave gaps. It plots the line as if I have
interpolated chosed even if my Active chart have "Not plotted (leave gaps)
chosed in Tools Options... Do you know why?
 

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

How do I plot "" as empty rather than zero in a chart 1
HOW THE HELL Can I get excell to stop ploting blank cells 4
how can an empty cell equate to non-plot point rather than zero? 2
Blank instead of "" 5
Excel 2002 Zero Values in Charts 2
Don't plot non-numeric cells 2
How to eliminate zero values on graphs when formula calculates 0? 3
How do I keep zero values from plotting in charts? 6

Top