Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Switch X and Y Axis in Excel

How to Switch X and Y Axis in Excel

Asmi DhakalBy Asmi DhakalAugust 9, 2022
how to switch x and y axis in excel

Re-entering data can be tedious, especially for longer spreadsheets. This problem must be quite common as Excel has simplified the process of switching the X and Y axes! 

Excel is one of the most preferred digital spreadsheets. Not only can you create complex databases, but you can also further simplify the representation through graphs! However, learning how to create graphs can be tricky. Especially for newer users, you may input all your data correctly but in incorrect axes!

If you relate to this situation, you have nothing to be worried about because we’re here to help. Keep reading this article to learn more about how you can switch the X and Y Axis in Excel.

Table of Contents

  • How to Switch X and Y Axis in Excel?
    • Switch Row/Column
    • From Select Data Source
    • For Scatter/Bubble Chart
  • What to Do If Switch Row/Column is Greyed Out?

How to Switch X and Y Axis in Excel?

By default, Excel picks the first selected series as the X axis. If you do not want to go through the hassle of editing the data, you can simply arrange the data you want on the X axis to precede the row with data you want on the Y axis.

Switch Row/Column

You can easily swap your graph’s X and Y axis from the Switch Row/Column option on the Chart Design ribbon in Excel. This works for almost all charts except the scatter and bubble chart.

Follow these steps to switch the axes on your graph in MS Excel:

  1. Launch MS Excel to open your workbook.
  2. From your workbook, select your graph. 
  3. A new tab, Chart Design, will appear on the menu bar; Select it.
  4. From the ribbon, locate the Data section, then click the Switch Row/Column option.
    SwitchRownAndColumRibbonExcel

From Select Data Source

You can also find the Switch Row/Column button on the Select Data Source window on Excel. You can open the select data source window through the Select Data option on the Chart Design tab. 

Here are the steps you can refer to switch X and Y axis in Excel through the Select Data Source window:

  1. Open your Excel file. 
  2. Select the diagram from the workbook. This should make the Chart Design tab appear on the menu bar. 
  3. Hop on to Chart Design and click on the Select Data Source option from the data section. You can also right-click on your diagram and choose Select Data to open this window.
  4. On the new window, locate and select the Switch Row/Column button. This will automatically prompt Excel to swap the data value between the X and Y axis.
    switch-row-columns
  5. Click on OK to confirm the changes.

For Scatter/Bubble Chart

You have to take the longer route if you’ve used the scatter or bubble chart to represent your data. All you have to do is interchange the data values of each axis. 

The Switch Row/Column option is greyed out for these diagrams as the data range is too complex. However, you can swap the series value of all charts from the Select Data Source dialog box in Excel. Follow these steps to swap the values of the X and Y axes:

  1. Open your Excel workbook. 
  2. From your spreadsheet, select your scattered graph. 
  3. Right-click on the diagram and click on the Select Data option.
    select-data  
  4. A new window, Select Data Source, will appear on your screen. Under Legend Entries (Series), select Edit.
  5. Copy-paste the value under Series X values and Series Y values.
    X-and-Y-axis
  6. Select OK on the dialog box. Repeat this step for the Select Data Source window.

What to Do If Switch Row/Column is Greyed Out?

Sometimes, when you switch from the scatter graph to other diagrams the Switch Row/Column button is greyed out. In this case, you will have to manually swap the data series from the X axis to Y axis. 

You can still edit data the entries to switch data from the Select Data Source dialog box through these steps:

  1. Open Microsoft Excel to open your workbook.
  2. Right-click the graph and click on Select Data.
    select-data
  3. From the Select Source Data window, select Edit under Legend Enteries (Series)
  4. In the Edit Series window, copy the data under Series values, then select remove the value. Click OK. 
  5. Press Windows key + V to open the clipboard and turn it on.
  6. From Select Source Data Window, select Edit under Horizontal (Category) Axis Labels. Copy the data value under the Axis label range then remove it, then select OK.
  7. Repeat Step 3 to open the Edit Series dialog box.
  8.  Select Windows key + V to open the clipboard. From the clipboard, copy the Axis label range value and paste it under Series values. Click OK.UseClipboardtoCopyPasteAxisValue
how-to
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
what is port 443

Port 443: Everything You Need to Know About It

May 18, 2023
Best-1200W-PSU

8 Best 1200W PSUs for Extreme PC Builds in 2023

May 16, 2023
Best-1000W-PSU

10 Best 1000W PSUs in 2023

May 16, 2023
You may also like
Brother-Printer-Not-Printing

Brother Printer Not Printing? Here’s How to Fix It

May 25, 2023
0x80300024

6 Ways to Fix 0x80300024 Error in Windows

May 25, 2023
reverse video search

How to Do a Reverse Video Search

May 25, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday, editor@technewstoday.com | Tech Central Pvt. Ltd.

Type above and press Enter to search. Press Esc to cancel.