Using a secondary chart axis for multiple scales
Get more Excel tips on https://trainingtube.com
In this video you will learn how you can present multiple scales by use of a secondary axis in Microsoft Excel. You can use a secondary axis when you want to display different types of data within the same chart. To get started I have already navigated to this page by clicking on the Insert tab in my Microsoft Excel.
To insert a chart to this dataset I simply click on any area of my data set then I navigate to the ribbons at the top and click on the downward arrow next to the chats ribbon. A pop-up menu appears and I click on ''All charts'' and navigate towards the bottom where I click on combo.
From the preview I can select the secondary axis that I want to add. In this case I want to have the microwave data presented in a line so I click on line checkbox and once I'm done I click on OK and as you can see immediately a chart has been displayed on my screen with both the columns and the line charts represented. I can also click on the bottom right corner of the chart so I can adjust the size of my chart to make it bigger or smaller.
If I would like to shift to a different axis I double click on either the columns or the line chart and a horizontal panel with the format letter series appears on the screen. This is where I have the option of shifting from the one axis to another by just a click. I can then be able to adjust all other features to my liking.