The column chart allows you to create a separate axis for the 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 by selecting the checkbox and change the column axis chart type to line
then click the OK
button.Ok
button is clicked, the column chart will show the separate axis for the target column.NOTE:
Combination chart
also allows the user a create a separate axis for the multiple series charts. Please refer to this link for reference.