Ask Your Question
0

How can I distribute X-Axis Values not equally but relativ to their size?

asked 2018-12-05 13:25:37 +0100

Evlmnkey gravatar image

Hello and thanks in advance!

Of course I am using LibreOffice Calc (6.1.3.2) and want to create a Diagram, Lineplot. Example Picturehttps://imgur.com/rXZivCJ

These are measurements and the measurement points (X-Axis) are not equally distributed ("finer") in lower number regions. But now x(70) is as far from x1(00) as x(2000) from x(3000) which distorts the Data I want to show.

How can I have them distributed equally to their size and a line-graph interpolated in between?

Thanks so much! I am an avid forum user in my area of expertise as well and hope this is a good post with all relevant info.

edit retag flag offensive close merge delete

Comments

If you want the x-axis to be a linear scale, that is with equally-spaced divisions all the way along, then you could try plotting your data on an x-y scatter plot (the name is a bit misleading). When you choose a chart type from the menu, choose "XY (Scatter)"

ve3oat gravatar imageve3oat ( 2018-12-05 16:26:12 +0100 )edit

That's exactly what s/he does not want ;-)

erAck gravatar imageerAck ( 2018-12-05 17:02:27 +0100 )edit

Guess I didn't understand the meaning intended by "distributed equally to their size', and that the example diagram linked was in fact desirable. Please ignore my suggestion.

ve3oat gravatar imageve3oat ( 2018-12-05 20:34:38 +0100 )edit

Now I think I was wrong and you were right. The diagram linked in the question seems to show the behaviour the OP does not want and wants an XY diagram instead.

erAck gravatar imageerAck ( 2018-12-05 22:41:56 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-12-05 17:00:47 +0100

erAck gravatar image

Use a Line diagram, but make the first column a category range instead of a data series range, i.e. copy the UCE Y-Values range to Categories and then delete UCE from the Data Series list.

edit flag offensive delete link more

Comments

Just tell me if this was wrong and I'll delete the answer.

erAck gravatar imageerAck ( 2018-12-05 22:42:23 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-12-05 13:25:37 +0100

Seen: 49 times

Last updated: Dec 05