Create excel chart with two vertical axes - add secondary axis

Hello, how can I create an excel chart with one vertical axis on the left side and second vertical axis on the right side ? Is it possible to add the second axis on existing chart ?
17 Feb 2021 at 05:24 PM
0pnshow more
NicoleNicole
Hi,

Charts with two vertical axes are in Excel known as "Combo charts". You can create a new combo chart or change an existing chart to combo type.

To create a new combo chart, you have to select the cells with data, click on Insert section and choose Recommended Charts:

excel create new chart insert

Then in All Charts, select Combo type and choose which data should be related to the second axis:

excel create new chart with two vertical axes

To add secondary axis on existing chart, you have to click on the chart with left mouse button, choose Change Chart Type and modify the layout according to your preferences:

excel create chart with two axis add secondary axis

19 Feb 2021 at 03:13 PM
0pnshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook & Twitter
2021 AnswerTabsTermsContact us