How to Change the Y Axis in Excel
Updated April 24, 2022, by Steve Larner, to add details on changing the Y-axis.
Working knowledge of Excel is one of the must-have skills for every professional today. It’s a powerful tool that can transform how you see and understand data in any work environment. What’s more, with new updates, its functionality and processing power are expanding, making it capable of handling massive amounts of data.
In this article, we’ll guide you through how to change the y-axis (vertical/value axis) in Excel and tell you more about its functionality.
Changing the Y Axis Scale in Excel
Assuming that you want to change the vertical value axis (Y-axis) in your Excel chart/graph, you can customize its values to cover an extensive range or transform it into a logarithmic scale. Sometimes, you may want a different set of values than what Excel prepopulates. For instance, you may want to shrink the range down a little to focus on a particular range or reverse the order of the axis. No matter what values and text you want to show on the vertical axis (Y-axis), here’s how to do it.
- In your chart, click the “Y axis” that you want to change. It will show a border to represent that it is highlighted/selected.
- Click on the “Format” tab, then choose “Format Selection.”
- The “Format Axis” dialog box appears.
- To change the beginning and ending or minimum and maximum values, go to the “Axis Options -> Bounds” section, then type a new number in the “Minimum” and “Maximum” boxes. If you need to revert the change, click on “Reset.”
- To change the interval/spacing of tick marks or grid lines, go to the “Axis Options -> Units” section, then type a new number in the “Major unit” or “Minor unit” option depending on your needs. If you need to revert the change, click on “Reset.”
- To change the crosspoint of the X and Y axis, go to the “Axis Options -> Vertical axis crosses” option, then choose “Automatic,” “Axis value,” or “Maximum axis value.” If choosing “Axis value,” type the value you want to become the crosspoint.
- To change the displayed units, such as changing 1,000,000 to 1 where units represent millions, go to the “Axis Options -> Display units” section. Click the dropdown next to “Display Units,” then make your selection such as “millions” or “hundreds.”
- To label the displayed units, go to the “Axis Options -> Display units” section. Add a checkmark in the “Show display units label on chart” box, then type your “unit label” such as “Numbers based in millions.”
- To switch the value axis to a logarithmic scale, go to the “Axis Options -> Display units” section, then add a checkmark in the “Logarithmic scale” box.
- To reverse the order of the vertical values, go to the “Axis Options -> Display units” section, then add a checkmark in the “Values in reverse order” box. This action also reverses the horizontal axis to reflect accuracy in your chart or graph.
- To adjust the placement of tick marks, go to the “Tick Marks” section. Click the dropdowns next to “Major Type” and “Minor type,” then make your selection.
- To change the axis label’s position, go to the “Labels” section. Click the dropdown next to “Label Position,” then make your selection.
Changing the Display of Axes in Excel
Every new chart in Excel comes with two default axes: value axis or vertical axis (Y) and category axis or horizontal axis (X). If you’re making a 3D chart, in that case, there’s going to be a third one called the depth axis (Z). Editing or changing any of the axes results in modifying how information is presented, what you can read from the chart, and where the emphasis lies.
Hiding and Unhiding Axes
When you’re working with different types of projects, it might come in handy to hide some of the axes to make your graphs more legible or to stress important numbers. Here’s how to do this:
- Bring the cursor to the chart where you want to change the axes’ appearance.
- Go to “Design,” then go to “Add Chart Element” and “Axes.”
- You’ll have two options: “Primary Horizontal” will hide/unhide the horizontal axis, and if you choose “Primary Vertical,” it will hide/unhide the vertical one.
- Click on the option you need.
Adjust Axis Marks
Whenever you create a chart, you’ll notice that all marks and labels are there by default. Adjusting the way they’re on display will remove any clutter or unnecessary information. With fewer marks and using bigger and smaller labels, your table will have a clearer structure, and your team will be able to use it without any issues.
Change the Alignment and Orientation of Labels
In a situation where you have multiple categories in your chart, there’s an option that helps you align labels on all levels. Additionally, you can also decide on the amount of space between the levels of labels. Here’s how to do this:
- Bring your cursor to the chart and click anywhere.
- Click on the “Chart Tools” and then “Design” and “Format” tabs.
- When you open the “Format” tab, click on the “Format Selection” and click on the axis you want to change.
- If you go to “Format,” “Format Axis,” and “Text Options,” you can choose for the text to be aligned vertically, horizontally, or to have a customized angle.
Change Appearance of Text and Numbers
Microsoft Excel allows you to format text and numbers in the category axis. Here’s how to format your text:
- Click on the axis that you want to customize.
- Click on “Home” toolbar and click on the formatting options you’d like to apply.
When you’re ready to format numbers, follow these steps:
- Click on the axis that you want to customize.
- Open the “Format” tab and select “Format Selection.”
- Go to the “Axis Options”, click on “Number” and select “Number” from the dropdown selection under Category. Here, you can choose among different numbering formats.
Change the Color of a Chart
For people working with charts all the time, it’s pivotal to mark them clearly, and sometimes the best way to do it is to use color. If your table is black and white and in need of some color to make it more impactful, here’s how to add it:
- Bring the cursor to the chart where you want to change the color.
- Click on “Design” tab. The “Chart Styles” option is located on the upper right corner.
- Once you click on it, you’ll see the “Style” and “Color” options for your chart.
- Scroll and choose the color and chart style you like.
Change the Color of Rows and Columns
Just a bit of color can make all the difference in a table. If you want to add color to alternate rows and columns, here’s how to do it:
- You need to select all the cells or columns.
- Press “Home” and “Format as Table.”
- Choose a style that supports different colors and shading.
- Go to “Design,” and from there you can check and uncheck all the rows and columns you want shaded.
One of the most powerful Microsoft Office tools at any workplace around the world is Microsoft Excel. There’s no business that cannot benefit from using charts, lists, and various graphs to analyze, budget, organize or keep track of expenses. Excel proved itself pivotal for multiple industries that rely on the systematization that Excel provides.
Now that you know how to change and hide axes and format text and numbers, you’ll become acquainted with excel a bit more and use it fully. Are you currently working with Excel? Are you using it to make lists at home, or is it strictly for business?
Let us know in the comments section below.
Disclaimer: Some pages on this site may include an affiliate link. This does not effect our editorial in any way.
One thought on “How to Change the Y Axis in Excel”