Dynamic Line chart - empty values

[Bilingual]

Hi, i have made a very simple linechart, with Months on the horisontal axis, but as data for the months august-december has not materialized, the line chart makes this annoying break at the last month with data (juli) , how do you make the line just stop at the last point of data?

Kind regards Daniel

 

[Toadstool]

I recently answered a similar question with two suggestions (use an Excel Table or suppress the axis heading).

Take a look here: https://www.mrexcel.com/forum/excel...charts-over-time-post5325210.html#post5325210