I am plotting percentages from a table that will be filled with weekly
values, but not all of the weeks are completed yet, so future weeks are
plotting as zero.

Cells being graphed contain a A1/B1 formula to get a percentage, resulting
in a divide by zero error. I suppressed the error and tried to set the cell
as 'blank' by using =IF(ISERROR(A1/B1),,A1/B1).

I tried setting the Tools Options Graphs - Plot Empty Cells As: Not
Plotted, leave gaps. Problem is, even though the value is 'blank' if error =
true, it is no longer a 'blank' cell by Excel's interpretation, so the
'blank' cells are still plotted as zero on the chart.

Has anyone else overcome this problem?

Thank you very much! - Brian