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 is clicked, the column chart will show the separate axis for the target column.
Combination chartalso allows the user a create a separate axis for the multiple series charts. Please refer to this link for reference.