The column chart allows you to create a separate axis for multiple series.
Please follow these steps to create a separate axis in the column chart.
Change
button in the Chart Type and Axis
property. By default, the secondary axis option is not checked.Secondary axis
option, select the checkbox and change the column axis chart type to line
. Finally, click the OK
button.OK
button is clicked, the column chart will display a separate axis for the target column.NOTE: The
combination chart
also allows the user to create a separate axis for the multiple series charts. Please refer to this link for more information.