Ask Your Question

How do I tie a secondary Y axis to chart data?

asked 2017-03-10 19:00:42 +0200

Dave Mc gravatar image

I want to connect several of my Y data series to a secondary Y axis. I am running Linux Mint 18.1. I cannot access the main menu bar while I am creating the chart in the chart wizard. Inside the chart wizard, I could not find a way to insert a secondary Y axis. Once the chart is created, I can edit it and insert a secondary Y axis from the main menu bar, but, it is not tied to my data. I cannot find a a way then to access chart elements outside the wizard. I cannot find a way to reopen the chart wizard on an existing chart.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-11 00:29:38 +0200

Lupp gravatar image

updated 2017-03-11 16:54:19 +0200

I don't think you can insert the second y-axis while the wizard is active.
Having created a preliminary chart you can edit it. If the 'Chart Wall' is selected the context menu will contain the option 'Insert/Delete Axes'. Insert the second y-axis and select any data series. Choose 'Format Data Series...' from its context menu. The dialog you get will contain an 'Options' tab ... There you are.

(Editing:) See also this attached example.

edit flag offensive delete link more


Thank you for your response. However, what I am seeing is different. 1. If I select chart wall on the menu bar, the tabs are border, area, and transparency, which only have cosmetic settings. If I actually click on the chart wall, the context menu does not contain insert/delete axis. 2. If I select insert from the menu bar, I can turn on secondary Y axis, but see no way to tie it to data. After turning on secondary axis, if I select data range, then data series, I see no options button, cont.

Dave Mc gravatar imageDave Mc ( 2017-03-11 15:33:18 +0200 )edit

cont, I see no options button or any way to assign secondary Y axis to a Y Values data series.

Dave Mc gravatar imageDave Mc ( 2017-03-11 15:34:07 +0200 )edit

The attachment was a huge help. I now see the context menu that you referred. The answered my question. Thanks!

Dave Mc gravatar imageDave Mc ( 2017-03-12 03:17:33 +0200 )edit

Did you also notice the usage of columns D and E in the example? I consider this a valuable gadget in specific with charts containing a second y-axis. I do not know another workable way to define the relative adjustment of the two y-axes in cases where the main series are not constant. Scaling the axes as needed via the chart editor is a nightmare to me.

Lupp gravatar imageLupp ( 2017-03-12 11:24:24 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-10 19:00:42 +0200

Seen: 1,201 times

Last updated: Mar 11 '17