Graph dropping to 0

[chef]

Hi,
Thought this would have been simpler but been trying all sorts to no avail

I have months Apl-21 to Mar-22 in cells D7 to Q7
I then have formula in E8 to O8 and D9 to O9 that automatically populate looking up another sheet as the mths progress

I want to show the whole year on the axis as I dont want to have to go in each month and change data range and I also dont want to see rows of #N/A if that is the solution to stop the graph dropping to 0 after the current month
Ive tried Hidden and Empty cells data but that does not work for me

Apologies if this is a simple question but i'm struggling to fathom out a neat solution
Any nudge in the right direction would be greatly appreciated
regards

 

[popipipo]

Take a look at this site, maybe this will help you

Create a Dynamic Chart

Here's Debra's simple example of a dynamic chart that includes more points when more data is added.

peltiertech.com