When creating a chart, you may want to adjust the default scaling that Excel applies to an axis. This is relatively easy to do by following the steps outlined in this tip.
Most chart types have two axes: a horizontal axis (or x-axis) and a vertical axis (or y-axis). This example teaches you how to change the axis type, add axis titles and how to change the scale of the vertical axis.
To change the scale on the graph we should go to Format Axis options. In our example, we will change the minimum scale to 15,000 and maximum scale to 55,000 on the vertical axis.