I had the chart working like this and could see in the x-axis, "bounds":
But the data was bigger than the chart, thus:
So I increased the data range 10 lines ahead to cater for increases in the future, thus:
But this resulted in chaos. The x-axis messed up, and I can't edit the bounds as they've disappeared(!), thus: