Calc chart "same" value date X axis [closed]
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
please help