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

Of course I am using LibreOffice Calc (6.1.3.2) and want to create a Diagram, Lineplot. https://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 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)"

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

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

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

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

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

Sort by » oldest newest most voted

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.

more

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

( 2018-12-05 22:42:23 +0100 )edit

## Stats

Seen: 54 times

Last updated: Dec 05 '18