Hi There

I'm plotting a line graph on a range of cells and the formula in the series
of cells is this:

If(C7="Y",SUM($D$6:E7),"")

I want the chart to basically add a plot each day so the C column just tells
me that the next day has past.

At the moment when the value in column C is blank it is plotting these cells
as zero and continuing the line. How can I make the line stop when the Value
in C is blank?

Any help would be greatfully appreciated.

Thanks in advance

Jamie