A second y-axis in Excel permits you to plot two totally different units of knowledge on the identical chart, every with its personal y-axis. This may be helpful if you need to examine information that’s measured on totally different scales or has totally different models of measurement. For instance, you could possibly use a second y-axis to plot gross sales information and revenue information on the identical chart, though the gross sales information is measured in {dollars} and the revenue information is measured in proportion.
So as to add a second y-axis in Excel, first choose the information that you just need to plot on the second axis. Then, click on on the “Insert” tab and choose “Chart.” Within the “Chart Sort” dialog field, choose the kind of chart that you just need to create. Then, click on on the “Secondary Axis” checkbox. It will add a second y-axis to the chart. You’ll be able to then format the second y-axis as wanted.
