Microsoft Excel is a powerful spreadsheet tool widely used for data analysis, charting, and visualisation. One of the essential features Excel provides is the ability to create meaningful charts to represent your data effectively. Adding a secondary axis to your chart becomes crucial for accurate representation when dealing with datasets with diverse scales.
Here we’ve explained how to add a secondary axis to an existing chart and create a new one in Excel with a secondary axis.
Also read: How to add a title to Excel chart?
Add a secondary axis to an existing chart
If you have already created a chart on Excel for your datasheet and you want to add a secondary axis, then follow the steps below:
Step 1: Open the worksheet on Excel in which you want to add the secondary axis and select the chart to open the chart tools in the menu bar.
Step 2: Click on the Chart Design tab in the menu bar and then click on the Change Chart Type under the Type group ribbon.
Step 3: In the change chart type window, click on Combo available at the bottom of the sidebar.
Step 4: Now, on the right side, mark the box under Secondary Axis beside the series name for which you want to use the secondary axis. Click on the OK button to save the changes.
Step 5: A secondary axis will be added for your chosen series.
Also read: How to turn on the battery saver on your Chromebook?
Create a new chart with a secondary axis
To create a new chart with a secondary axis, follow the steps below:
Step 1: Select the data for the chart, then click on the Insert tab in the menu bar and click on the Combo Chart icon.
Step 2: In the options that appeared, click on the middle option, Clustered Column-Line on Secondary axis.
Step 3: Your chart with a secondary axis will be ready.
Also read: How to find external links in Excel?
