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