Thanks Jim, Dave, and Micky.

I should have specified that all of the blank cells do have formulas in
them.

So, if I return #N/A it fixes the issue of graphing the data, but it still
shows the data series title and marker type of the series with blank cells.
Is there a way to have this removed automatically if the series is blank?

Thank you again for your help.

"Jim Thomlinson" wrote:

Blanks are treated as zeros. Just the way it is. To get around it you need to
have the zeros turned into #N/A.

=if(B2 = 0, #N/A, B2)


--
HTH...

Jim Thomlinson


"DoubleZ" wrote:

I have created a graph in Excel 2007 that has 4 data series. However, in
many instances I will only have data entered for 1 or 2 of those series.
Currently, the blank series are being plotted as zero values.

Is there a way to define the data series so that if they are blank they will
be completely omitted from the graph?