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