How to Change X Values on Excel Graph

Changing the X-axis values on your Excel graph is one of the quickest ways to turn a confusing chart into a clear, insightful one. Whether you have typos, need to change the scale, or want to entirely swap out the data being displayed, knowing how to manipulate the horizontal axis is fundamental. This tutorial will walk you through several easy methods for customizing your X-axis values to make your data presentations more professional and understandable.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding the X-Axis in Excel

Before making changes, it helps to know what you’re working with. The X-axis, also known as the horizontal or category axis, typically displays the categories or independent variables of your data. For example, in a sales report, the X-axis might show months, product names, or sales regions.

Excel handles the X-axis differently depending on the data type:

• Category Axis: This is used for non-numeric labels like text (e.g., "North America," "Europe," "Asia") or dates that you want to be treated as distinct labels. Each label is spaced evenly along the axis.
• Value Axis: This is used when your X-axis itself contains numerical values, like in a scatter plot. The position of each data point is determined by its value, and the axis is a continuous numerical scale.

The method you use to change your X-axis values will depend on the type of chart you have and what you want to achieve.

Method 1: Edit the Source Data Directly

The simplest way to change your X-axis labels is to edit them right where they live - in your spreadsheet cells. Since your Excel chart is linked directly to your source data, any change you make there will be automatically reflected in the graph.

This method is perfect for quick fixes like correcting a typo, renaming a category, or rephrasing a label.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Instructions:

1. Locate Your X-Axis Data: First, find the column or row in your spreadsheet that contains the labels for your X-axis. In a typical bar or line chart, this is often the leftmost column of your selected data.
2. Select a Cell to Edit: Click on the specific cell containing the label you want to change.
3. Type the New Value: Type in the new text or number and press Enter.

As soon as you press Enter, you will see the corresponding label on your chart update instantly. For instance, if your X-axis shows "Q1", "Q2", "Q3", and "Q4", you can click into the cell containing "Q1" and change it to "Quarter 1" to make it more descriptive.

Example: Fixing a Sales Report Chart

Imagine your chart displays sales for different T-shirt sizes, but you notice "Medum" is misspelled. You simply navigate to the cell in your data table that says "Medum," correct it to "Medium," and the chart immediately updates with the correct spelling.

Method 2: Use the 'Select Data' Dialog Box

Sometimes you don't need to edit the existing labels but change the entire data range that your axis is looking at. Perhaps you created a chart and Excel mistakenly picked the wrong column for your axis labels, or you want to switch it to display a different set of categories altogether. The "Select Data" feature gives you complete control over this.

Step-by-Step Instructions:

1. Select Your Chart: Click anywhere on your chart to make it active. This will cause the "Chart Design" tab (or "Design" on older versions) to appear in the Excel ribbon at the top of the screen.
2. Open the Select Data Source Window: Go to the "Chart Design" tab and click on the "Select Data" button. This will open a new dialog box titled "Select Data Source."
3. Edit the Horizontal Axis Labels: In the dialog box, you'll see two main sections: "Legend Entries (Series)" on the left and "Horizontal (Category) Axis Labels" on the right. Look at the box on the right and click the Edit button.
4. Select the New Label Range: Another small window called "Axis Labels" will pop up. Your cursor will now be active in the "Axis label range" input field. Without closing this window, click and drag your mouse over the new range of cells in your spreadsheet you want to use as your X-axis labels.
5. Confirm Your Changes: Once you've selected the new range, its reference (e.g., =Sheet1!$A$2:$A$6) will appear in the input field. Click "OK" on the "Axis Labels" window, and then click "OK" again on the "Select Data Source" window.

Example: Charting Sales by Product Instead of by Date

Let's say you have a spreadsheet with three columns: Date, Product Name, and Sales. When you created a line chart, Excel automatically used the 'Date' column for the X-axis. But you want to compare sales by 'Product Name' instead. Using the steps above, you would click "Select Data," edit the "Horizontal Axis," and select the range of cells containing the product names. Your chart would instantly pivot to show products along the X-axis.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 3: Format the Axis to Change Scale and Intervals

For charts where the X-axis uses numerical values (like a scatter plot showing temperature over time), you may need to adjust the scale, not the labels themselves. You can control the minimum and maximum values displayed (the bounds) and the distance between the tick marks (the interval units). This is crucial for focusing on the most important part of your data and avoiding a cluttered axis.

Step-by-Step Instructions:

1. Open the Format Axis Pane: Right-click directly on the X-axis labels of your chart. A context menu will appear. Select Format Axis... from the list. This will open a "Format Axis" pane on the right side of your screen.
2. Adjust the Bounds: Make sure you've selected the "Axis Options" tab (often represented by a small bar chart icon). Here, you will find settings for "Bounds."
3. Change the Units (Intervals): Just below the "Bounds" settings, you'll see "Units."

Example: Cleaning Up an Ad Spend Chart

You have a scatter plot of daily ad spend vs. website visits. The ad spend (your X-axis) ranges from $53 to $487. Excel might automatically set your bounds to 0 and 500, with major units every 100. To make the chart more focused and readable, you could set the Minimum bound to 50, the Maximum to 500, and change the Major unit to 50, giving you clearer intervals ($50, $100, $150, etc.).

Method 4: Change Number and Text Formatting

Sometimes the underlying values are correct, but they are not displayed in an easy-to-read format. This is common with dates, large numbers, and currencies. The "Format Axis" pane is also your tool for this job.

Changing Number Formatting

In the "Format Axis" pane, scroll down and find the Number section. Expand it to see all your options. Here, you can change the category from a generic "General" to:

• Date: Lets you choose from various date formats, like "3/14/2024," "14-Mar-24," or just "Mar-24."
• Currency: Automatically adds a currency symbol (e.g., $) and formats the number with commas and decimal places.
• Percentage: Converts values like 0.25 to 25%.
• Custom: Allows you to create your own format code for ultimate control. For instance, a custom date format of mmm 'yy would display March 2024 as "Mar '24".

Graphed

Still Building Reports Manually?

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

Watch the Demo

Changing Text Orientation

If your X-axis labels are long, they can overlap and become unreadable. You can fix this by changing their orientation.

1. In the "Format Axis" pane, click the "Size & Properties" icon (looks like a square with resizing arrows). In some versions, this is located under the "Label" accordion in "Axis Options".
2. Look for the alignment settings, where you can modify the Text direction or enter a Custom angle.
3. Setting a custom angle of 45 degrees or -45 degrees tilts the labels, giving them more room. You can also choose "Stacked" to display the text vertically.

Applying these formatting options greatly enhances the overall clarity and professional look of your visuals.

Final Thoughts

Mastering a few simple techniques for changing X-axis values elevates your charts from basic-but-functional to polished and insightful. Whether you’re editing your source data, switching your label range with the "Select Data" tool, or using the "Format Axis" pane to fine-tune scales and formatting, you have full control over how your story is presented visually. These adjustments are small but make a massive difference in how easily your audience can understand your findings.

Building these charts in tools like Excel is incredibly useful, but it still often involves hours of clicking, formatting, and manual data wrangling. At Graphed, we’ve made this process nearly effortless. You can connect your data sources (like Google Analytics, Shopify, or even a Google Sheet) and simply ask in plain language for the chart you need. Prompts like, "Show me last quarter's revenue by product category as a bar chart" instantly generate a perfectly labeled, real-time visualization, letting you skip the manual setup and get straight to the insights.