Excel: change the scaling of an axis - how it works
In this practical tip, we will show you how to change the scaling of an axis in Microsoft Excel.
Excel: Change the scaling of the diagram axes
If you change the scaling of an axis in Excel, it is often easier to read a diagram. It also usually makes it more meaningful. To do this, you must first create a diagram.
- Place the mouse on the axis for which you want to change the scaling and click with the right mouse button.
- Then select "Format axis".
- Under the "Scaling" tab, you will now find the various sizes. Here you can enter values such as minimum, maximum and interval.
- Don't forget to save your changes with OK.