Help with Line Graph visualisation

I have a column & line graph in a work book.

I would like the "RED" & GREEN" lines to stop when the range of data in the relevant row ends, but then automatically increase when data is added.

please see attached for example.

all help greatly appreciated

Moggzy

Use =NA() instead of blanks

thanks.


the formula i am using is:

=SERIES('EV DASHBOARD'!$C$69:$E$69,'EV DASHBOARD'!$F$61:$BE$61,'EV DASHBOARD'!$F$69:$BE$69,6)


can you amend for me please?

Those are series in the chart and that's fine.
What you need to do is put =NA() in the cells where you entering data.


Once you enter new values lines on chart will appear.