Question

how to change the scales of value axis in excel??​

Answer 1

$<b>$ STEPS ⤵️⤵️

⭐point the mouse at y axis, right click on it and select format axis.

⭐the format axis dialog box will open. Select the axis options tab. Click on fixed option for minimum and enter 20 in the text box.

⭐similarly enter 200 in the maximum text box, click on close button the chart will display the value between 20 and 200.