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

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.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Quick Steps to Change Y Axis Scale in Excel

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 Scale Time on X Axis in Excel Chart (3 Quick Methods)


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

Read More: How to Break the Axis Scale in Excel (3 Effective Ways)


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 X Axis Scale in Excel (2 Useful Methods)


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.


Conclusion

I hope all of the suitable steps mentioned above to change 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

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo