IF formulas creates zeros in a line graph

R

Regulator

When Using an =IF(,,) function like =IF(A1="","",A1-A2) if A1 is blank Excel
still shows a zero in the graphs even when show blanks as zero option is not
selected. Any way to fix this?
 
N

Nick Hodge

You could replace your "" with N/A() this is not plotted

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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 to eliminate zero values on graphs when formula calculates 0? 4
Excel 2007 charts: want to avoid zero values 1
Dynamic graph 0
Automatic Macro to create 200 graphs 1
Suppres Zero or empty Cell value in a line graph 1
Hiding Data Points in a chart 2
Hidden and Empty Cell Settings 0
Line chart to zero 2

Top