Let’s say we have the below 3D Clustered Column Chart to show the comparison of the keyboard sale count over 4 consecutive years in 2 metro cities in India.
Now to change the axis scale in this chart please follow the below steps.
- Right click on the vertical axis and click ‘Format Axis’.
2. Now in the Format Axis Pane, enter the Maximum Bounds as 1000 and major Units as 200.
3. As you can see, below is how the graph looks with modified axis pane.