Chart Question

[plost33]

Is there a way to have excel NOT graph a cells value is the value is ""?

I have the following formual in some cells and when it graph's the cells which result in "" it graphs a value of zero. i want it to not graph anything at all.

=IF(F5<>"",G4+F5,"")

 

[danzon]

Excel will not chart #N/A errors...

try =IF(F5<>"",G4+F5,"#N/A")

 

[Steve=True]

You can also use

NA() instead of "#NA"


Steve=True
www.exceldashboardtemplates.com