Adding A Secondary Axis In Excel. Select secondary axis for the data series you want to show. Now, click the chart > select the icon of chart.
Adding a Secondary Axis to an Excel Chart
In the format data series pane that appears, go to the series options tab (the last one) and choose secondary axis. Select secondary axis for the data series you want to show. Web add secondary axis. Web you can add a secondary axis in excel by making your chart a combo chart, enabling the secondary axis option for a series, and plotting the series in a style different from the primary axis. This will open the insert chart dialog box. Secondly, in the format data series window, select secondary axis. In the charts group, click the recommended charts option. By default, excel adds a second y. Now, click the chart > select the icon of chart. Web select design > change chart type.
In the charts group, click the recommended charts option. By default, excel adds a second y. Web add secondary axis. This will open the insert chart dialog box. Web below are the steps to add a secondary axis to a chart: Web you can add a secondary axis in excel by making your chart a combo chart, enabling the secondary axis option for a series, and plotting the series in a style different from the primary axis. In the charts group, click the recommended charts option. Now, click the chart > select the icon of chart. Secondly, in the format data series window, select secondary axis. Select secondary axis for the data series you want to show. In the format data series pane that appears, go to the series options tab (the last one) and choose secondary axis.
