How to Modify the Axis Value to Change Chart's Appearance.

In many situations, you may need to modify the axis value to make your chart look better, if that is the situation, please refer to the following steps.

For example, please make a column chart with the data below.

Step 1: Select data, then in the Insert Tab, click Clustered Column in the 2 D Column section.

Step 2: After you will get the chart below.

Step 3: To make the differences among regions look better, you can change the minimum value of Y-axis:

- Double click Y-axis;

- In the Axis option window, change the minimum value to 10 (please change based on your own data);

Step 4: Now the chart is changed to the one below, and the differences among regions are obvious.

Download Example

Leave a Reply