A second y-axis in Excel means that you can plot two totally different units of knowledge on the identical chart, every with its personal y-axis. This may be helpful whenever you wish to examine information that’s measured on totally different scales or has totally different models of measurement. For instance, you can use a second y-axis to plot gross sales information and revenue information on the identical chart, regardless that the gross sales information is measured in {dollars} and the revenue information is measured in share.
So as to add a second y-axis in Excel, first choose the info that you simply wish to plot on the second axis. Then, click on on the “Insert” tab and choose “Chart.” Within the “Chart Kind” dialog field, choose the kind of chart that you simply wish to create. Then, click on on the “Secondary Axis” checkbox. This may add a second y-axis to the chart. You possibly can then format the second y-axis as wanted.
