Calc chart "same" value date X axis

[mkrmec]

hello

I am trying to do something for work, and I’ve been getting problems with the chart, actually how it’s drawn.

I have X value with a lot of same dates and
Y value with numbers

The problem is that I want all the X and Y to draw separate, not multiple dates (X) with multiple numbers (Y).

Is that possible?

Attached the simple calc file so you see what I mean.
http://www.filedropper.com/test_13

EDIT:
It works in MS Excel… should look like this:
http://www.filedropper.com/book1_4

[mkrmec]

please help

[horst]

Use the Line Chart instead of a x-y-scatter chart.

[mkrmec]

the problem was I was using cells that were formated as dates. I switched them to text and it works now. The stupidest little things…