How to Create an Excel 2016 Chart with Two Y Axes
Were going to show you how create an Excel 2016 Chart with Two Y Axes.
Once you have a chart and two sets of data plotted, left-click directly onto the line, columns, etc. of the set of data you want on the secondary axis. After selecting it, right-click it and choose Format Data Series.
…
Source: Geeks Tutorial (2023-07-08)