How to Change the Numbers on a Graph in Excel

Need to get the numbers on your Excel graph to look just right? You're not alone. Whether your axis scale is making your data look flat, you need to display currency instead of plain numbers, or you want to show values directly on your chart, manipulating the numbers is a must-have skill. This guide will walk you through everything you need to know about changing numbers on an Excel graph, from the raw data that powers it to the final formatting touches.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

The Golden Rule: Your Graph Is a Mirror of Your Data

Before we dive into formatting options, it’s essential to understand the core principle of Excel charts: a chart is a visual representation of the data in your worksheet. The heights of the bars, the points on a line, and the slices of a pie are all directly determined by the numbers in the cells you selected when you created the chart.

Therefore, the most direct way to change the values represented in the chart is to change the source data. If a bar representing May sales is at $15,000 but should be $16,500, you don't change the bar itself. You find the cell for May's sales in your table and update the value from 15000 to 16500. Excel will instantly update the bar on your graph.

However, more often than not, the underlying data is correct, but the way it's displayed on the graph needs tweaking. That’s what the rest of this guide will cover: formatting the chart axis, data labels, and scales without altering your source data.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Change the Numbers on a Chart Axis

The axis is the ruler of your chart - it provides the scale and a frame of reference for your data. Customizing it can dramatically improve readability and focus your audience's attention on what really matters. Nearly all of these formatting options can be found in the "Format Axis" pane.

To access the "Format Axis" pane:

• Right-click the axis you want to change (usually the vertical Y-axis for values, but sometimes the horizontal X-axis).
• Select Format Axis... from the dropdown menu. A pane will open on the right side of your screen.

1. Changing the Axis Bounds (Minimum and Maximum)

By default, Excel does a pretty good job of guessing what the minimum and maximum values of your axis should be. Sometimes, however, adjusting them can tell a much clearer story.

For example, imagine you're tracking monthly website traffic, and your numbers range from 95,000 to 100,000 visitors. If Excel sets the axis to run from 0 to 120,000, the small but important fluctuations between months will be almost invisible. By changing the minimum bound, you can zoom in on the action.

Here’s how to do it:

1. Open the Format Axis pane as described above.
2. Make sure the Axis Options tab (the one that looks like a bar chart) is selected.
3. Under Bounds, you'll see boxes for "Minimum" and "Maximum." They are likely set to "Auto."
4. To override this, simply type your new desired value into the box. For our website traffic example, you might set the Minimum to 90000.
5. Press Enter, and your chart axis will immediately rescale to show the new range.

To revert, just click the "Reset" button next to the box, and it will go back to Auto.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

2. Adjusting the Major and Minor Units

Look at the numbers running up your vertical axis. The space between each labeled number is the "Major unit." If your axis looks too cluttered or too sparse, adjusting this value can help.

• Major units control the labeled gridlines and numbers on the axis. If your axis goes up to 100, a major unit of 20 would create labels at 0, 20, 40, 60, 80, and 100.
• Minor units control the smaller, usually unlabeled, tick marks between the major gridlines. These add more granular detail but are often turned off for clarity.

To change these:

1. In the Format Axis pane under Axis Options, look for the "Units" section just below "Bounds."
2. Change the values in the "Major" and "Minor" boxes. If your axis is too crowded with numbers, increase the Major unit value. If the gaps are too big, decrease it.

There's no single right answer here, the goal is to create intervals that are easy for viewers to understand at a glance (e.g., intervals of 5, 10, 50, or 100 are usually better than 7.5 or 33).

3. Changing the Number Format (Currency, Percentages, Decimals)

What if your source data is a list of plain numbers like 54321, but you want your chart axis to show $54,321.00? You don't have to change your original data. You can format the numbers directly on the axis.

Here's the process:

1. In the Format Axis pane, scroll down to the bottom and expand the Number section.
2. You'll see a "Category" dropdown list that looks very similar to the formatting options you find in worksheet cells.
3. You can choose presets like:
4. Select your desired category and customize the options. Your chart axis labels will update in real time.

How to Change the Numbers Shown Directly On the Graph

Sometimes clarifying the axis isn't enough, you need to show the exact value of each bar, line point, or pie slice. This is where Data Labels come in.

Adding and Formatting Data Labels

Data Labels are text elements linked to individual data points in your chart.

To add them:

1. Click once on your chart to select it. Three buttons will appear in the top-right corner.
2. Click the plus icon (+), labeled "Chart Elements."
3. Check the box next to Data Labels. The values from your source data will immediately appear on the chart.

To customize them further, right-click on one of the new data labels and select Format Data Labels.... This will open a new pane on the right with several useful options:

• Label Contains: You can choose to show more than just the value. You can include the Series Name or Category Name, which is great for pie charts.
• Label Position: Depending on the chart type, you can move the labels around to make them more readable, placing them on the Outside End, Inside End, Center, etc.

Pro-Tip:

If just one or two labels are overlapping, you don't have to move them all! Click once on the data labels to select the whole series, then click a *second* time on just the one problematic label. You can then drag that individual label to a better position.

• Number Formatting: Just like with the axis, there is a "Number" section at the bottom where you can change the format to Currency, Percentage, and so on. This is especially helpful if your primary axis shows one unit (e.g., Dollars), but your data labels need to show something else (like units sold). You can do this by tying it to a secondary axis or formatting the labels independently.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Techniques for Big Numbers: Using Display Units

Is your chart tracking revenue in the millions or billions? An axis showing numbers like 5,000,000, 10,000,000, and 15,000,000 can look cluttered and hard to read. Excel has a brilliant, slightly hidden feature to fix this.

The "Display units" feature automatically abbreviates your large numbers for you.

To use it:

1. Open the Format Axis pane for your value axis.
2. Under Axis Options, look for the dropdown menu labeled Display units.
3. Select an option from the list, such as Hundreds, Thousands, Millions, Billions, or even Trillions.
4. Excel will instantly divide your axis numbers by that unit and add a text label indicating the unit (e.g., "$15M" instead of "$15,000,000"). This makes for a much cleaner and more professional-looking graph.

Final Thoughts

Mastering how you display numbers in Excel charts elevates your reports from simple data dumps to compelling visual stories. Whether you're adjusting axis bounds to focus on key fluctuations, formatting currency and percentages for clarity, or using data labels to pinpoint exact values, you now have the tools to make your charts communicate effectively.

The manual process of creating these reports - downloading data, putting it in Excel, and wrestling with formatting options - is exactly why we built Graphed. Instead of spending hours manually creating and formatting charts, you can connect your data sources directly to Graphed and use plain English to ask for the visuals you need. Simply type, "a line chart of my Shopify revenue versus Facebook Ad spend by month," and you get a real-time, interactive dashboard instantly, letting you focus on insights, not axis settings.