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

[zp]

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

[Regina]

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.

[zp]

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