How to Change Sig Figs in Excel Graph Axis
Nothing ruins a good Excel chart faster than a cluttered, messy axis. You’ve done the hard work of gathering and analyzing your data, but Excel’s default settings leave your axis labels looking like a long string of unnecessary numbers, like "$15.830485". This article will show you exactly how to take control of your chart’s axes, focusing on changing the significant figures and decimal places to make your graphs clean, professional, and easy to read.
Why Default Axis Labels Are a Problem
When you create a chart in Excel, it does its best to automatically set the scale for your vertical (Y) and horizontal (X) axes. More often than not, this results in axis labels with far too many decimal points. This isn't just a minor visual annoyance, it actively hurts the quality of your report.
It reduces readability: Your audience has to mentally round the numbers to understand the chart’s message. Cluttered numbers create cognitive friction, making it harder to grasp the key insights at a glance.
It looks unprofessional: A chart filled with overly precise, unformatted numbers looks sloppy, as if you just hit "Insert Chart" and didn't bother to finalize the details.
It can be misleading: Showing too many decimal places can imply a level of precision that doesn’t actually exist in your original data.
The goal is to present data in a way that is immediately understandable. By formatting your axis labels, you guide your audience's focus to the trends and insights, not the distracting, hyper-specific numbers.
The Easiest Fix: Formatting the Axis Numbers
The most direct way to control the decimal places and significant figures on your graph's axis is through the "Format Axis" menu. This panel contains all the settings you need to clean up your chart.
Let's walk through it step-by-step. Imagine you have a chart where the Y-axis labels look like 10.00, 20.00, 30.00, etc., but you just want them to show 10, 20, 30.
Step-by-Step Instructions:
Select the Axis to Format: Click directly on the axis whose labels you want to change. For instance, click on one of the numbers on the vertical (Y) axis. You'll see a box appear around the axis labels, confirming you've selected it.
Open the Format Axis Pane: Right-click on the selected axis. A context menu will pop up. From this menu, choose Format Axis. This will open a settings panel on the right side of your Excel window.
Navigate to Number Options: In the "Format Axis" pane, make sure you're in the "Axis Options" tab, which is represented by a small bar chart icon. Scroll down within this tab until you see a section called Number. Click on it to expand the options.
Change the Category and Decimal Places: This is where you make the changes.
By default, the category is often set to "General". Click the dropdown menu and change it to Number.
Once you select "Number", a new option will appear called Decimal places. Now, simply type the number of decimal places you want to show. To remove them entirely, enter 0 and press Enter.
Instantly, you’ll see the axis labels update on your chart. The messy, overly specific numbers are replaced with clean, simple integers.
A Deeper Look: Sig Figs vs. Decimal Places
It's important to clarify a key point: Excel's formatting tools directly control decimal places, not textbook "significant figures." However, by intelligently managing the decimal places for a given range of numbers, you effectively control the significant figures.
For numbers greater than 1, setting decimal places indirectly sets the significant figures. If your axis values are 12.345, 15.678, and 18.901, setting the format to one decimal place (12.3, 15.7, 18.9) effectively gives each number three significant figures.
For numbers less than 1 (e.g., 0.00582), the number of decimal places determines the precision. Displaying four decimal places (0.0058) gives you two significant figures.
For most business and reporting contexts, thinking in terms of "how many decimal places do I need for clarity?" is the most practical approach. The good news is that for scientific contexts, Excel has a dedicated formatting option.
Handling Scientific Data with Scientific Notation
If you're working with very large or very small numbers, using the "Number" format can lead to awkward labels. A number like 0.00000045 is nearly impossible to read on an axis. This is where scientific notation comes in handy.
In the same Format Axis > Number menu, you can select the Scientific category. Here, the "Decimal places" field controls how many digits appear after the first non-zero digit.
For example:
A value of 45,120,000 with two decimal places in Scientific format becomes 4.51E+07.
A value of 0.0000897 with two decimal places becomes 8.97E-05.
This formatting makes extreme values compact and keeps the chart's axis tidy.
Advanced Control with Custom Number Formats
Sometimes the built-in categories aren't quite right. What if you want to show millions as "$1.5M" instead of "$1,500,000"? For this level of control, you need Custom number formats.
In the Format Axis > Number panel, select the Custom category at the bottom of the list. Here, you can enter a format code to tell Excel exactly how to display the numbers. This may seem intimidating, but you only need to know a few key codes to do some powerful things.
Here are some of the most useful custom codes for chart axes:
0.0: Displays at least one digit before and one after the decimal point. Perfect for forcing a consistent look (e.g., 5.0, 10.5, 0.2).#,##0: Displays a comma as a thousands separator and rounds to the nearest whole number (e.g., 1,235).$#,##0: Adds a dollar sign and a thousands separator.#,##0.0,"K": The real powerhouse. This code divides the number by 1,000 and appends a "K" for thousands. For example, 15,800 becomes 15.8K.#,##0.0,,"M": Similarly, two commas divide the number by a million and append an "M". The number 2,500,000 becomes 2.5M.
To use them, simply choose the Custom category, type the desired code into the "Format Code" box, and click Add. Your axis will immediately reflect the new, slick formatting.
Putting It All Together: A Practical Example
Let’s say you have a chart tracking website sales, and the Y-axis labels generated by Excel are: $0.00, $50,000.00, $100,000.00, $150,000.00.
These labels are long and take up too much space. Here’s how you’d fix it:
Right-click the Y-axis and select Format Axis.
Go to the Number section.
Change the Category to Custom.
In the "Format Code" box, type:
$0,"K"
The axis labels will instantly change to: $0K, $50K, $100K, $150K. Your chart is now cleaner, more professional, and communicates the data's scale much more effectively.
A Quick Tip: Linked to Source Data
Inside the "Number" formatting pane, you might notice a checkbox that says "Linked to source". If this box is checked, the chart axis will try to inherit the same number formatting used in your source data cells. Sometimes, the quickest way to fix an axis is to first format the data in your columns, and then check this box. However, manually setting the axis format as described above gives you more granular control and is generally the more reliable method for perfecting your charts.
Final Thoughts
Cleaning up the axes is one of the quickest ways to elevate an Excel chart from a draft to a polished, professional visualization. By using the "Format Axis" pane, you can easily control decimal places, apply scientific notation, or use custom codes to make your data stories clear and compelling.
Manually adjusting every report in Excel or Google Sheets can be a repetitive drain on your time, especially when you’re pulling data from multiple sources like Google Analytics, Shopify, or Facebook Ads. At Graphed, we automate this entire process. You can connect your data sources in a few clicks, and then simply ask in plain English for the dashboard you need - like, "Show me a chart of sales by marketing channel from Shopify for the last quarter." We instantly build a live, interactive visualization for you, saving you from the tedious work of formatting charts and lets you focus on finding insights faster.