I just wanted to add, that I have tried the NA() but this places "#NA" in the
cell, which defeats the purpose of leaving the cell blank. It will prevent
the cell from being plotted, but then the spread sheet is full of data that I
do not want to see. Is there another way?

"groj" wrote:

How can I keep an excel chart from plotting a blank cell as zero?

I am plotting a series of numbers, each month. If the month is not here yet,
then that cell is calculated as a blank. But the chart still plots it as
though it was zero.

Any ideas?

Thanks