The cell isn't empty, it contains a formula.

Try this:

=IF(B12=0,NA(),(100-(B13/(SUM(B12:B13))*100)))

That'll return a #N/A "error" but will be ignored in the chart.

If you don't want to see the #N/A's displayed in the cells you can use
conditional formatting to hide them by setting the font color to be the same
as the fill color.

Condtional Foramtting
Formula Is: =ISNA(cell_ref)
Set the font color to be the same as the fill color

Biff

"Stu" wrote in message
...
This is the formula in a cell which is plotted as a data point on a chart

=IF(B12=0,"",(100-(B13/(SUM(B12:B13))*100)))

It works fine, but I don't want the chart to plot it if the cell is blank
("")
I went into Tools - Options - Chart and selected Plot Empty Cells As Not
plotted
But it still plots the empty cell as zero
Please advise