Excel Chart Problem

[tinynoo]

I want my chart to display a line graph without dropping at the end of the line where data is still to be inputted.

I need the chart to have the blank cells included so that it updates automatically. The cell references used in chart refer back to other worksheet. Using IF statement:

=IF('Week 45'!$C$7<=0,"",'Week 45'!$C$7))

means line on chart still drops when I just want it to stop if this makes sense.

Can anyone help out on this one?

 

[Ginny2222]

Maybe I'm reading this wrong, but anytime I create a Line Chart I include the Cols or Rows that contain the blank cells that will update. On updating the data the Chart updates.
Ginny

 

[tinynoo]

Thanks Ginny,

I have the blank cells selected but whilst they are empty line graph drops to zero until data inputted into cell; I just want the line to stop at end. Hope that makes more sense.

 

[HaHoBe]

Hi, tinynoo,

as you use Formulas you most hopefuly use Dates. You could use a dynamic Range based on the starting values and the MATCH function narrow thge plotted range to only those values (or raise an error and not get the other values to be shown as values in the chart while using #N/A).

Ciao,
Holger