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:  | |||||||||||
| |||||||||||
|
| |||||||||||
  | |||||||||||
| 2021 AnswerTabs | Terms | Contact us |
