Stephanie, what kind of chart are you using? Can you give an example of how
your data table looks like?
br,
Henk

"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?