Empty cells not in chart

Hello all,

I have searched the internet but I kind get the right answer to my question. I'm trying to get empty cells out of the chart (without adjusting the source range).
In the attchement you'll see what I mean. The chart already doesn't show the empty cells starting from 15 till 24. But I I want the chart to just show the x-axis till 14 as the rest are empty cells. I do not want to adjust the source of the chart because the 15 till 24 will be filled in automatically later this year and I want the chart to automatically refesh as the empty cells are being filled.

Anyone know the answer to this?
Chart.png

Alright, I don't know what Dynamic ranges are so I will try to study/understand it and check if it works for me.

I will let you know. Anyway thanks

Thanks MrShorty,

The Dynamic Ranges is exactly what I needed