Auto Populating a linear graph

[GarryFreeman]

Hello

Could someone please help. I am trying to create a graph that will push 2021 out as soon as the zeros (in week 5 in this example) are populated but also without the graph falling to Zero as per below

Many Thanks in advance

Garry

 

[GarryFreeman]

Bumping up as I posted this late yesterday.
Thanks

 

[RoryA]

Assuming you have formulas in that table, change them to return NA() rather than 0. You can use conditional formatting to mask the errors if you like.

 

[GarryFreeman]

Perfect RoryA

Thanks for your help