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.


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.

how to change y axis scale in excel


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.

Make 2-D Bar Chart to Change Y Axis Scale

  • 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.

Make 2-D Bar Chart to Change Y Axis Scale


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.

Change Y Axis Scale in Excel

  • 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.

Change Y Axis Scale in Excel

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 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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo