How to Change the Units of a Chart Axis in Excel

Staring at an Excel chart with a vertical axis that reads \$1,000,000, \$2,000,000, \$3,000,000 is enough to make anyone’s eyes glaze over. All those zeros take up space, make the chart feel cluttered, and force your audience to count digits instead of focusing on the story your data is telling. Fortunately, cleaning this up is simple. This tutorial will walk you through exactly how to change the units of a chart axis in Excel, transforming your crowded visuals into clean, professional, and easy-to-read graphs.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother Changing Axis Units?

Before diving into the "how," let's quickly touch on the "why." Adjusting the scale of your chart's axis isn't just a minor formatting tweak, it's a critical step in effective data visualization. A well-formatted axis accomplishes three key things:

• Improves Readability: The primary goal is clarity. Displaying \$2M instead of \$2,000,000 or 500k instead of 500,000 instantly makes the chart easier to interpret at a glance. It reduces visual noise and helps your audience absorb the information faster.
• Enhances Professionalism: A clean, well-labeled chart looks polished and deliberate. It shows that you've thought about your audience and have taken the time to present your data in the most effective way possible, which is essential for reports, presentations, and dashboards.
• Keeps the Focus on the Story: Your chart's purpose is to tell a story or reveal an insight. When the axis labels are complicated, your audience gets bogged down in deciphering the numbers. By simplifying the units, you allow the pattern, trend, or comparison in the data to be the star of the show.

The Go-To Method: Using the "Format Axis" Pane

The most direct way to change your axis units is through Excel’s "Format Axis" menu. This powerful pane gives you full control over how your axis is displayed. Let’s walk through it with a common example: a column chart showing monthly sales figures that are in the millions.

Imagine your data looks like this:

When you create a chart from this data, the vertical (Y) axis labels will be long and full of zeros. Here’s how to fix that.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions:

1. Select the Axis: First, click on the chart to select it. Then, right-click on the vertical (Y) axis labels — the numbers you want to change. A context menu will pop up.
2. Open the Format Axis Pane: From the context menu, choose Format Axis.... This will open a sidebar on the right side of your Excel window, which contains all the formatting options for the selected axis.
3. Navigate to Axis Options: In the "Format Axis" pane, make sure you're on the "Axis Options" tab. It's usually the one represented by a small bar chart icon.
4. Find "Display units": Scroll down within the Axis Options until you see a section called Display units. It typically defaults to "None."
5. Choose Your Units: Click the "Display units" dropdown menu. You’ll see options like Hundreds, Thousands, Millions, Billions, and even Trillions. For our example, select Millions.

Instantly, you'll see your chart's vertical axis transform. The labels will change from \$2,000,000, \$3,000,000 to much cleaner labels like 2.0, 3.0, and so on. Excel automatically adds a label like "Millions" next to the axis to provide context, so viewers know what the numbers represent.

Pro Tip: Always Check the Axis Title

While Excel is smart about adding a simple label, it's good practice to make it even clearer. If Excel's automatic "Millions" label feels out of place or you've disabled it, be sure to update your chart's axis title. For instance, you could change the vertical axis title to "Monthly Sales (in Millions)" or add a note in the main chart title. Context is everything, you don't want someone misinterpreting \$2.5 as just two dollars and fifty cents!

Beyond Display Units: Taking Control of Your Axis Scale

Changing the display units is often the biggest win, but the "Format Axis" pane offers more tools for fine-tuning. Understanding bounds and major/minor units can elevate your charts from good to great.

Setting the Bounds (Minimum and Maximum)

Under "Axis Options," the first thing you'll see is "Bounds," with a box for Minimum and Maximum. By default, Excel sets these automatically based on your data.

• Minimum Bound: This is the lowest value on your axis. Sometimes, Excel starts charts at zero, but if all your values are very large (e.g., between 5,000,000 and 5,500,000), starting the axis at 4,500,000 can help accentuate the variation between data points. Be careful with this, though, as starting an axis above zero can sometimes exaggerate differences.
• Maximum Bound: This is the highest value. You might manually set this to add some "breathing room" at the top of your chart or to keep the scale consistent across multiple charts for fair comparison.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Adjusting Major and Minor Units

Right below the bounds, you'll find "Units," with boxes for "Major" and "Minor." These control the spacing of the gridlines and labels on your axis.

• Major Unit: This determines the interval between the labeled tick marks. If your axis goes from 0 to 1,000, a Major unit of 200 would create labels and gridlines at 0, 200, 400, 600, 800, and 1,000. If your axis looks too crowded, increase the Major unit. If it looks too sparse, decrease it.
• Minor Unit: This determines the interval for the smaller, typically unlabeled tick marks that appear between the major ones. This adds more granular detail but can also create clutter if overused. In many cases, it's best to leave this alone or turn it off entirely for a cleaner look.

A Practical Example

Let’s say you are charting daily website users, and your analytics range from 45,300 to 78,500 over a month. Here’s how you could use all these controls together:

1. Excel's default might be an axis from 0 to 80,000. You change the Minimum Bound to 40,000 to better "zoom in" on the actual performance.
2. The numbers are long, so you set the Display units to Thousands. Now your labels are 40, 50, 60, etc.
3. Excel might set the Major Unit to 10.0 (representing 10,000). To add a little more detail, you could change it to 5.0 (representing 5,000).
4. Finally, you add a vertical axis title: Daily Users (in Thousands).

With just a few clicks, you’ve created a perfectly scaled and easy-to-read chart that precisely reflects your data.

What About the Horizontal Axis? Formatting Dates and Things

While the vertical (value) axis is the most common target for unit changes, you can also format the horizontal (category) axis, especially when dealing with dates.

If you have a time-series chart (e.g., daily sales over a year), the X-axis can get very crowded. You can adjust the date groupings in the "Format Axis" pane:

1. Right-click on the horizontal (date) axis and select Format Axis...
2. Under "Axis Options," you'll see a slightly different set of "Units."
3. Here, you can set the Base unit to Days, Months, or Years. Changing this from Days to Months, for example, will group your labels and tick marks by month.
4. The Major Unit here controls the frequency. For a base unit of "Days," a major unit of 7 would place a label every week. For a base unit of "Months," a major unit of 3 would place a label every quarter.

Playing with these settings can turn an unreadable daily timeline into a clean, high-level summary view.

Troubleshooting Common Axis Issues

Sometimes things don't go as planned. Here are fixes for a couple of common hiccups.

"My Axis Numbers Are Overlapping!"

This is a classic problem on both horizontal and vertical axes. Here are your options:

• Increase the Major Unit: The simplest fix is to show fewer labels by widening the interval between them.
• Change Text Orientation: In the "Format Axis" pane, go to the "Size & Properties" tab (the a-box icon) and find "Text direction" or "Custom angle." Changing the angle of your labels to 45 degrees or orienting them vertically can often solve spacing issues.
• Make the Chart Bigger: Sometimes, the chart is simply too small to fit everything. Drag the corner to resize it.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

"The 'Display Units' Option is Greyed Out!"

This almost always means Excel doesn't recognize the data in your source cells as numbers. It thinks they are text. Double-check your data column for unwanted spaces, apostrophes, or other non-numeric characters. A quick way to fix this is to select the column, go to the "Data" tab, and use the "Text to Columns" feature, just clicking "Finish" right away. This often forces Excel to re-evaluate the cell contents and convert them properly to numbers.

Final Thoughts

Adjusting the units and scale of an axis is one of the most impactful formatting changes you can make in Excel. By moving beyond the default settings and taking control of the display units, bounds, and major intervals, you can transform a cluttered graph into a strategic tool that communicates information clearly and effectively.

At Graphed, we see this manual tweaking as a common friction point in data reporting. The time spent clicking through menus in Excel to get one chart right adds up fast, especially when you have to do it every week. We built our tool to automate this process. You can connect your data sources (like Google Analytics, Shopify, or even a Google Sheet) and simply ask for a dashboard using plain English. A prompt like, "Show me a bar chart of monthly revenue in millions for Q4" tells our AI to build the visualization, connect the live data, and handle the unit formatting automatically. Our goal is to let you move straight from question to insight, eliminating the tedious steps in between.