A second y-axis in Excel lets you plot two totally different units of information on the identical chart, every with its personal y-axis. This may be helpful if you need to evaluate information that’s measured on totally different scales or has totally different models of measurement. For instance, you might use a second y-axis to plot gross sales information and revenue information on the identical chart, although 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 simply 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 simply need to create. Then, click on on the “Secondary Axis” checkbox. It will add a second y-axis to the chart. You possibly can then format the second y-axis as wanted.
