Ask Your Question
1

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

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 close merge delete

1 Answer

Sort by » oldest newest most voted
2

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

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 176 times

Last updated: Jul 07 '17