We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc Charts : How can I assign 2 values for the same axis ? [closed]

asked 2017-07-07 18:56:40 +0200

zp gravatar image

Hello, apologies if this has been answered elsewhere, I couldn't find it. I'm making a chart which compares 2 data sets, one of which is entered in complete numbers and one of which is entered as multiples of K (so "24" = 24,000). Comparing the two is impossible as entered because the scale is completely distorted. A colleague was able to make a chart which gives 2 different values for the same axis, using Excel, but I don't have Excel and can't ask her to make the chart for me every time. Is there any way to do this in LibreOffice ?

Here is the chart made by the colleague to illustrate what I mean : on the left side is the scale for the complete numbers (blue line), on the right side is the scale for the multiples of K (grey line).

example chart

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-09 12:58:34.337710

1 Answer

Sort by » oldest newest most voted

answered 2017-07-07 23:28:03 +0200

Regina gravatar image

Start as usual. Then in edit mode of the chart (gray border) go to menu Insert > Axes. Check "Y axis" in section "Secondary Axes". Then select the data series, which you want to be assigned to the second axis. From context menu choose "Format Data Series" or from menu Format choose item "Format selection". Select option "Secondary Y axis" in section "Align Data Series to" in the tab "Options". You might need to set the scaling of the second axis manually.

edit flag offensive delete link more


Brilliant, that's exactly what I needed, thank you very much for the answer.

zp gravatar imagezp ( 2017-07-10 16:46:19 +0200 )edit

Question Tools

1 follower


Asked: 2017-07-07 18:56:40 +0200

Seen: 739 times

Last updated: Jul 07 '17