How to use "assume zero" on data series without messing up dates?

Hello everyone,
I’m trying to use ‘assume zero’ on data series in a chart with dates on the x-axis.
Whenever i try to use it the x-axis get’s messed up and shows dates starting with 1999 instead of the entered values.
Is there a trick, so it only shows the entered dates?

Don’t leave a blank cell in the dates column when there is no data. The number 0 date is 1899-12-30.

If you secondary click on the chart line and choose Format Data Series… - Options tab, you can set how LibreOffice will Plot missing values. Assume zero will bring the line to Y=0 if there is a valid date value in a row without its corresponding data.

image description

Tested with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions.

Press edit below your question if you want to add more information; also can comment an answer.

Check the mark (Correct answer mark) to the left of the answer that solves your question.