Hi,

Is this a typo? =if(C25="",N/A(),Sum(C22:C25))
as it should be =if(C25="",NA(),Sum(C22:C25))

Cheers
Andy

StephanieH wrote:
I have a chart that is plotting null values. I tried the formula
=if(C25="",N/A(),Sum(C22:C25)). I've also deleted the formula to create a
completely null cell.

I've been to Tools, Options, Chart and selected
Plot empty cells as
Not plotted, zero and Interpollated
As well as turning Plot Visible Cells only (turned it on and off)

Nothing seems to make a difference.

Any suggestions?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info