Ask Your Question
0

Calc chart "same" value date X axis [closed]

asked 2012-11-28 12:55:07 +0100

mkrmec gravatar image

updated 2012-12-07 14:26:23 +0100

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

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by manj_k
close date 2014-06-01 23:10:35.404779

Comments

please help

mkrmec gravatar imagemkrmec ( 2012-12-07 14:34:27 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2012-12-07 22:58:36 +0100

horst gravatar image

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

edit flag offensive delete link more

Comments

1

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...

mkrmec gravatar imagemkrmec ( 2012-12-08 22:39:10 +0100 )edit

Question Tools

Stats

Asked: 2012-11-28 12:55:07 +0100

Seen: 957 times

Last updated: Dec 07 '12