# How to Change Y Axis Scale in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

While working in Microsoft Excel with the sales-related worksheets, sometimes we need to change the Y-axis scale for the convenience of our work. The chart shows you a trend in the share of total sales they contribute, NOT a trend in their absolute value. Changing the Y-axis scale in an Excel chart is an easy task. This is a time-saving task also. Today, in this article, weâ€™ll learn three quick and suitable steps to change the Y-axis scale in Excel effectively with appropriate illustrations.

Table of Contents

## How to Change Y Axis Scale in Excel: with Easy Steps

Letâ€™s say, we have a dataset that contains information about several Sales representatives of XYZ group. The Name of the Sales representatives and their sales in several months is given in columns B, C, and D respectively. From our dataset, we will apply the Insert ribbon to create a chart in Excel. Hence, we will change the y-axis scale of that chart. Hereâ€™s an overview of the dataset for todayâ€™s task.

### Step 1: Create a Dataset with Proper Parameters

In this portion, we will create a dataset to create a chart in Excel. We will make a dataset that contains information about several Sales representatives of the Armani group. We will change the y-axis scale after creating the chart of the Sales representatives. So, our dataset becomes.

Read More:Â How to Change X Axis Scale in Excel

### Step 2: Make 2-D Bar Chart to Change Y Axis Scale

Using Insert ribbon, we will import a chart from our dataset to change the y-axis scale. This is an easy task. This is a time-saving task also. Letâ€™s follow the instructions below to change the y-axis scale in Excel!

• First of all, select the range of data to draw a chart. From our dataset, we select C4 to D16 for the convenience of our work.

• After selecting the data range, from your Insert ribbon, go to,

Insert â†’ Charts â†’ 2-D Column

• As a result, you will be able to create a 2-D column chart which has been given in the below screenshot.

### Step 3: Change Y Axis Scale in Excel

In this section, we will change the y-axis scale of the chart. The y-axis value is \$0 to \$25,000. We will change it from \$0 to \$42,000. To do that, follow the instructions below.

• Now, we will change the y-axis scale of the chart. Firstly, press left-click on any value of the y-axis. Secondly, press right-click on the y-axis. As a result, a window will appear in front of you. From the window, select the Format Axis option.

• Hence, a Format Axis will appear in front of you. Now, from the Axis Options, Fixed the minimum value, and the minimum value is \$0. After that, Fixed the Maximum value, and the maximum value is \$42,000. Further, Fixed the Major unit value, and the major unit value is \$7,000. After that, simply press ENTER on your keyboard.

• Finally, you will be able to change the y axis scale which has been given in the below screenshot.

Read More:Â How to Change Axis Scale in Excel

## Things to Remember

ðŸ‘‰ Use Insert ribbon to create a 2-D column chart.

ðŸ‘‰ Press ENTER on your keyboard while completing the requirements of the Axis options option.

Download Practice Workbook

## Conclusion

I hope all of the suitable steps mentioned above to change the y-axis scale in the chart will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

## Related Articles

<< Go Back to Excel Axis ScaleÂ | Excel ChartsÂ |Â Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF