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.

How to Have Three Secondary Axes on Excel 2007. Excel 2007's secondary axis feature enables you to view two different data ... Add 2 to all X1 values to yield 0, 22 and 101. Divide those values ...

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.

Adding A Secondary Axis Let’s say we want to also add conversion rate to the chart. I changed the Revenue series back to a column chart to decrease chart junk.