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 ?

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:



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



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: