This article explains how to add a secondary axis to a chart in Excel so you can view unlike categories on the same graph. These instructions work in Excel in Microsoft 365, Excel 2021, Excel 2019 ...

How to Add a Second Y-Axis on Excel & Make a Second Series at the End of the Chart. Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet.

Under the Secondary Axis, click the last checkbox. A preview of the Custom Combination Chart will be previewed in the middle of the dialog box. Then click OK .

In the Format Data Series pane, click Secondary Axis and change the Gap Width to 500%, as shown in Figure G. Doing so reduces the bar’s width so it looks less like a column and more like a line.