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: ![]() | |||||||||||
| |||||||||||
| |||||||||||
![]() ![]() ![]() ![]() | |||||||||||
2022 AnswerTabs | Terms | Contact us |