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.
Changebutton in the
Chart Type and Axisproperty. By default, the secondary axis option is not checked.
Secondary axisoption by selecting the checkbox and change the column axis chart type to
linethen click the
Okbutton 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.