• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Get Droid Tips

Get Droid Tips

Custom ROM | CyanogenMod | Android Apps | Firmware Update | MiUi | All Stock ROM | Lineage OS |

  • Android
  • Games
  • iPhones/iPad
  • Social Media
  • Windows
  • LineageOS 17.1
  • Android 10
  • iOS 14
  • Free Among Us for PC
  • Write for US
  • Watch IPL 2020 For Free
Home PC Tips and Tricks

How To Change The Y-Axis In Microsoft Excel

Updated on December 25, 2020 by Swayam Prakash

Advertisements

Microsoft Excel is one of the oldest and trusted applications you will find on Windows. We use it to create, store, and present data of various kinds. It allows the graphical representation of data by using graphs and charts. A basic graph has two components, x-axis, and y-axis. Both the axes represent two types of dat related to each other. Sometimes, people do mistakes in representing the data correctly. I mean what should be the x-axis they present that in the y-axis. There arises the requirement to switch the axes. So, in this guide, I will show you how to change the Y-axis in Microsoft Excel.

For switching the axes you do not have to change the values in the excel sheet. Also, you don’t have to delete or remove anything from your data. All you have to do is select the axis you wish to switch. Then you can use a function to switch the values of the Y-axis to X-axis and vice-versa. Let’s check out how to do that.

change Y-axis of graph in Microsoft Excel

Change The Y-Axis In Microsoft Excel

The steps are pretty easy to follow. here it goes. As I mentioned earlier we will simply swap the values present on the x-axis to the y-axis. Similarly, the values on the y-axis will move to the x-axis.

Advertisements
  • Open Microsoft Excel
  • Then open the worksheet that has the graphical data represented via the x-axis and y-axis.
  • Right-click on the Y-axis of the graph
  • A menu will show up. From that click on Select Data
  • A new window with the title Select Data Source will open
  • Click on Edit
  • Then open any text editor on your PC
  • Copy the values from the axes to the text editor
  • Then under the Edit Series dialog box, you have to give the following function
    'Switch Axis'!$ range of the cell

You may be confused. Let me explain the above formula. The range specifies the cells between which you have represented the data in the regular linear form.

  • There will be two fields Series X values and Series Y values.
  • As per the previous representation, the cells will be specified for both the above fields
  • Simply use the formula stated above and swap the values of series Y with series X.
  • Once you change the y-axis (or x-axis) value click on OK to confirm the action
  • Then you will see immediately the Y-axis value of the graph is now changed to X-axis and vice versa.

So, that’s how you can change the Y-axis on Microsoft Excel. You don’t have to delete anything or prepare the datasheet from scratch. Just swap the field values of the Y-axis with the X-axis as I have explained above.

More Guides,

  • How to Make Pie Chart in Microsoft Excel
  • A Complete List of Best Microsoft Excel Shortcut
  • Getting High CPU Usage in Excel | How to Fix

Tagged With: Microsoft, Microsoft Excel

Primary Sidebar

Buying Guide

Top 6 Smartphones on Black Friday Deals 

Best Motherboards for the AMD Ryzen 9 5900X

Best Power Supply Unit (PSU) For Nvidia RTX 3090, 3080, And 3070 GPU

Best 3D Mu6 Dummy Head Recording Earphone

Best Hidden Cams To Buy in 2020

60Hz vs 144Hz vs 240Hz Monitors – Differences and Purchase Guide

How To Use PayPal On Amazon To Shop Safely?

RTX 3070 vs 3080 vs 3090: Differences, Performance, Design, Price, and More

Geforce RTX 3080 and RTX 3090 Pre-Order Guide: Where To Buy in India

How Much Will it Cost in India for Nvidia GeForce RTX 3070 / 3080 / 3090?

Advertisements
Advertisements

Footer

Signal Private Messenger Alternatives for Android and iPhone

How to Change Android DNS Settings

Download Google Camera for Samsung Galaxy M12 [GCam APK]

How to Change Google Drive Backup and Sync Folder Location

How to Stop Signal From Telling You When Your Contacts Join

Download Google Camera for Oukitel C22 [GCam APK]

Download Latest Disney+ APK v1.11.3+ | Added All Language List

Fix: Cannot Delete Key: Error While Deleting Key on Windows 10

How to Fix Your Slow SSD on Windows 10

How to Recover PowerPoint Password on Windows 10

How to Switch Windows Hello Login method from PIN to Password?

Best CSV File Viewer Software for Windows 10

How to Disable Adobe Acrotray.exe from Startup

How to Use Microsoft’s PowerToys on Windows 10?

How To Add New WhatsApp Contact Using QR Code

Wondershare Document Cloud – All Around Document Solution

What is Doordash Error Code 400 and How to Fix It?

Why Does Zoom Error Code 3113 Appears and How to Fix?

Zoom Error 2011 | What This Error Code Mean and How To Fix it?

How to Find If Someone Deleted your Conversation on Snapchat

How to Activate Discovery Plus on TV

© 2021 · Get Droid Tips

  • About Us
  • Contact Us
  • Privacy Policy
  • Disclaimer
  • Editorial Policy
  • Terms of Use
  • Write for Us