Tip : avoiding a line drops to the bottom in a combination chart with missing data

Sometimes, when creating a combination chart, you've got columns combined with a line chart.  When setting out the x-axis as a timeline with years or months for example, it sometimes happens that there's no data for a certain time period, for example in the future.

In that case, the column disappears, but the line suddenly drops to the bottom, as in the screenshot below.


That isn't so pretty.  Things get worse when there are even more years or months in the future where you see a flat line at the bottom of the graph.

Wouldn't it be good to let the line stop all together just as the column does, thereby losing the drop.

Turns out that's easy.  Just make sure that the value isn't 0, but "null" using an expression kind of like the following :


The result is something like this :