Change the value scale of a chart to improve view – How to

Change the value scale of a chart to improve view – How to

This quick tip shows you how to change the value scale of a chart to improve its view in Excel.

Since we use Excel on a Windows PC to complete this task, we suggest you do the same. However, you can still follow along on any operating system that has Excel.

Introduction

How to change the value scale of a chart to improve view.

So, this chart kind of looks good already. Overall, you can clearly see the difference between the values. However, let’s see if we can improve the view, even more.

To improve this chart, what we plan to do is, change the value (Y-axis) scale to a different range. Instead of going from 0 to 250, maybe we can go from 60 to 210. That would give us a range of 150 (210 – 60). In addition, we can change the interval from 50 to 30. Now, that would give us the same amount of values on the value scale.

After we make that change, we expect to see more vertical space between each column.

Steps to change the value scale of a chart

Below are the steps to change the value scale of a chart.

The Steps

Follow the steps below to improve the vertical view of a column chart.

Step 1: Format the axis
Step 1: Format the axis.
  1. Right-click on the value axis. A shortcut menu appears.
  2. Under the shortcut menu, select Format Axis… Afterwards, the Format Axis… box opens.
How to change the value scale - Format axis.
  1. Under Axis Options, for the bounds, change the minimum value to 80 and the maximum value to 200.

    Remember, we thought a scale of 60 to 210 would be great. However, we tried that, and it did not give us much of a vertical difference. In constrast, this view is even better. It stretches the top column value almost to the top.
     
  2. For the interval units, we chose 20. Likewise, 30 would had worked too.

Success! Changing the value scale of a chart to improve its view

Success!

There you have it! You have maximized the vertical space of your chart. In most cases, you will probably keep the scale as is, when you first created it. But, at least you know you can do something as little as changing the scale to improve the view of a chart.


Related


Excel lessons  Education home  Techronology home