Ask Your Question

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

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

Evlmnkey gravatar image

Hello and thanks in advance!

Of course I am using LibreOffice Calc ( and want to create a Diagram, Lineplot. Example Picture

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


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 +0200 )edit

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

erAck gravatar imageerAck ( 2018-12-05 17:02:27 +0200 )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 +0200 )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 +0200 )edit

1 Answer

Sort by » oldest newest most voted

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

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


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

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

Question Tools

1 follower


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

Seen: 74 times

Last updated: Dec 05 '18