=IF(AB4=0,"",AC3+AB4) Plotting as 0 on graph

[Tarvalon]

I have a few graphs in one workbook. To make the copying and pasting of formulas a little less painless I have formulas like "=IF(AB4=0,"",AC3+AB4)" all over it. However, it is still plotting as zero on the graphs. I need it to not appear on the graph until the formula result is not zero or not null.

Please help.

Thanks

 

[Steve=True]

Hi Tarvalon,

This is a simple fix, change the 2 quotes to NA()

excel does not graph na() values for most chart types.

Here is a sample tutorial:

http://www.exceldashboardtemplates.com/?p=696


steve=true

 

[Tarvalon]

ROCKIN!!! Thank You!!!

 

[Steve=True]

You are welcome.

Glad it worked for you.

Steve=True