How to Change Excel Chart X and Y Axis

Creating a chart in Excel is the easy part, but making it tell the right story requires a few tweaks. One common adjustment is changing how data is plotted on the X and Y axes. This article will walk you through how to swap your chart's X and Y axes, manually select your axis data, and make essential formatting changes to make your charts clear and impactful.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding the X and Y Axis in Excel

Before we start swapping things around, let's review the two main axes on a standard Excel chart. Understanding their roles is crucial for visualizing your data effectively.

• The X-Axis (Horizontal Axis): Also known as the category axis, this is the horizontal line at the bottom of the chart. It typically represents independent variables or categories, like time periods (months, years), product names, or geographic regions. Think of it as the 'what' or 'when' you are measuring.
• The Y-Axis (Vertical Axis): Also known as the value axis, this is the vertical line on the left side of the chart. It represents the dependent variable - the data you are measuring. This is typically a numerical value, like sales figures, website traffic, temperatures, or quantities. Think of it as the 'how much' or 'how many.'

In short, Excel plots the values from the Y-axis against the categories on the X-axis. Problems arise when Excel guesses wrong and plots your categories as values, or vice versa. Fortunately, fixing this is simple.

Method 1: The Quickest Fix - "Switch Row/Column"

The simplest way to swap your X and Y axis data is by using Excel’s built-in "Switch Row/Column" feature. This one-click solution is perfect when your data is structured in a simple table, with headers in the first row or first column.

Let's say you have a simple table showing monthly sales for two products:

Your Data Table:

If you create a column chart from this, Excel might plot the Products on the X-axis and show the months as different colored bars, which might not be what you want.

You probably want to see the Months along the X-axis to show performance over time. Here’s how to fix it:

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 Your Chart: Click anywhere on the chart object to select it. When selected, you'll see a border around the chart, and two new tabs will appear on the Excel Ribbon: "Chart Design" and "Format."
2. Navigate to the Chart Design Tab: In the Excel Ribbon at the top, click on the Chart Design tab.
3. Click "Switch Row/Column": In the "Data" group within the Chart Design tab, click the button labeled Switch Row/Column.

Instantly, Excel will swap the data. Your months will now be on the horizontal (X) axis, and your products will be listed in the legend, showing a much clearer trend over time.

Method 2: Manually Editing the Data Source

Sometimes the "Switch Row/Column" button is grayed out or doesn't give you the exact result you need, especially with more complex data layouts. For ultimate control, you can use the "Select Data Source" dialog box to manually define what goes on each axis.

This method gives you point-and-click control over which parts of your spreadsheet are used for the chart's legend (series), axis labels (categories), and values.

Step-by-step Instructions:

1. Access the Select Data Source Window: Right-click on your chart and choose Select Data... from the context menu. This will open the "Select Data Source" window.
2. Understand the Dialog Box: This window has two main panels:
3. Edit Your Data Series: Let’s say you want to manually swap the chart we used in the first example. In the "Legend Entries (Series)" panel, you can select a data series (e.g., "Product A") and click the Edit button.
4. A new "Edit Series" window will pop up. Here, you can change two things:
5. Edit Your Axis Labels: In the "Horizontal (Category) Axis Labels" panel, click the Edit button. A new window will appear, allowing you to select the range of cells in your worksheet that should be used as the labels for your X-axis. Click in the box, then drag your mouse to select the cells containing your desired labels (e.g., the cells with "Jan," "Feb," "Mar").
6. Confirm Your Changes: Once you've set the correct ranges, click OK in the respective windows to apply your changes.

This method is more hands-on but provides the flexibility needed to build charts from non-standard or separated data ranges within your sheet.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Customizing Axis Titles and Labels

Swapping the axes often reveals another problem: missing or unclear titles. It’s hard to understand a chart if the X-axis just says "1, 2, 3," and the Y-axis has no label. Here’s how to add and edit axis titles for clarity:

1. Select the chart.
2. Go to the Chart Design tab. On the far left, click the Add Chart Element dropdown.
3. Hover over Axis Titles and choose either Primary Horizontal to add a title for the X-axis or Primary Vertical for the Y-axis.
4. A placeholder text box ("Axis Title") will appear on your chart. Click into this box and type your desired title (e.g., "Month" for the X-axis and "Sales Revenue ($)" for the Y-axis).

For even faster access, you can click the green “+” icon that appears on the top right of a selected chart. A menu will pop up where you can check the box next to "Axis Titles."

Advanced Axis Modifications

Once you’ve mastered swapping axes and adding titles, you can further refine your charts with these advanced formatting options.

Changing the Axis Scale

Sometimes, Excel’s default scale on the Y-axis doesn't effectively show the variation in your data, especially if all your values are clustered high up. You can adjust the minimum and maximum bounds to zoom in on your data.

1. Right-click on the Y-axis (the vertical axis with the numbers) and select Format Axis...
2. A "Format Axis" pane will open on the right side of your workspace. Under Axis Options, you'll see a section for "Bounds."
3. Here, you can manually type in a new value for the Minimum and Maximum bounds. For example, if all your sales figures are above $50,000, setting the Minimum bound to 50000 can make the differences between months more pronounced.

Reversing Axis Order

Need to flip the order of your categories? Maybe you want your chart to show the most recent month first, or list products in a different order.

1. Right-click the axis you want to reverse (either X or Y) and select Format Axis...
2. In the "Format Axis" pane, under "Axis Options," simply check the box that says Categories in reverse order (for the X-axis) or Values in reverse order (for the Y-axis). The chart will update instantly.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Dealing with Scatter Plots (XY Charts)

It's important to note that Scatter (XY) charts behave differently from line or column charts. On a scatter plot, both axes are value axes - they both plot numerical data. You typically use them to show the relationship between two different sets of numbers, like ad spend vs. revenue.

Because there is no "category" axis, the "Switch Row/Column" button doesn't swap the axes. To flip the X and Y data on a scatter plot, you must use the Select Data Source window (Method 2 above).

1. Right-click your scatter plot and select "Select Data..."
2. Select your data series from the list and click "Edit."
3. In the "Edit Series" window, you'll see fields for Series X values and Series Y values. You need to manually swap the cell ranges entered in these two boxes.

It’s a fully manual swap, but it ensures you’re explicitly telling Excel which data set should determine the horizontal position and which should determine the vertical position of each point.

Final Thoughts

Customizing your Excel charts is all about making your data easier to understand. Whether you're using the one-click "Switch Row/Column" feature for a quick fix or diving into the "Select Data" dialog for more complex control, mastering axis manipulation gives you the power to present your information clearly and professionally.

While mastering Excel is a valuable skill, pulling data from multiple places and wrestling with chart settings every week can become exhausting. At Graphed, we decided there had to be a better way. We help you connect your data sources - like Google Analytics, Shopify, and Facebook Ads - and use simple, natural language to build the dashboards you need. Instead of setting up axes, you can just ask, "Show me my sales revenue by month for the last quarter," and get an interactive, live-updating chart in seconds.