November 25, 2020

How to change Axis scale in a graph or Chart in Excel

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.

  1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *