Did this article
help you?

This helped me

How to Change Axes in Excel

This wikiHow will teach you how to change the axes in Excel. This is useful if you need to change the data on your Y-axis to your X-axis and vice versa.

Steps

  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e9\/Change-Axes-in-Excel-Step-1.jpg\/v4-460px-Change-Axes-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/e\/e9\/Change-Axes-in-Excel-Step-1.jpg\/aid11943596-v4-728px-Change-Axes-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    If you're in Excel, you can go to File > Open or you can right-click the file in your file browser.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a4\/Change-Axes-in-Excel-Step-2-Version-2.jpg\/v4-460px-Change-Axes-in-Excel-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/a4\/Change-Axes-in-Excel-Step-2-Version-2.jpg\/aid11943596-v4-728px-Change-Axes-in-Excel-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can click either the X or Y axis since the menu you'll access will let you change both axes at once.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/06\/Change-Axes-in-Excel-Step-3-Version-2.jpg\/v4-460px-Change-Axes-in-Excel-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/0\/06\/Change-Axes-in-Excel-Step-3-Version-2.jpg\/aid11943596-v4-728px-Change-Axes-in-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":550,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This is usually in the third grouping of the menu that pops out at your cursor.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/09\/Change-Axes-in-Excel-Step-4-Version-2.jpg\/v4-460px-Change-Axes-in-Excel-Step-4-Version-2.jpg","bigUrl":"\/images\/thumb\/0\/09\/Change-Axes-in-Excel-Step-4-Version-2.jpg\/aid11943596-v4-728px-Change-Axes-in-Excel-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll see this on the left side of the window that pops up.
    • An "Edit Series" window will pop up. What you need to do here is add the data here that is showing up on the other axis.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5e\/Change-Axes-in-Excel-Step-5-Version-2.jpg\/v4-460px-Change-Axes-in-Excel-Step-5-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/5e\/Change-Axes-in-Excel-Step-5-Version-2.jpg\/aid11943596-v4-728px-Change-Axes-in-Excel-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    " You'll most likely want to copy the information from both axes into a notepad before you copy and paste over it.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c4\/Change-Axes-in-Excel-Step-6-Version-2.jpg\/v4-460px-Change-Axes-in-Excel-Step-6-Version-2.jpg","bigUrl":"\/images\/thumb\/c\/c4\/Change-Axes-in-Excel-Step-6-Version-2.jpg\/aid11943596-v4-728px-Change-Axes-in-Excel-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    " Once you have the data switched, you'll be able to continue.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/81\/Change-Axes-in-Excel-Step-7.jpg\/v4-460px-Change-Axes-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/8\/81\/Change-Axes-in-Excel-Step-7.jpg\/aid11943596-v4-728px-Change-Axes-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll need to click Ok until all the windows are closed.
    • You'll note that your chart has changed and displays the updated axis information. [1]
    Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit

      Advertisement

      You Might Also Like

      How to
      Lock the Gallery on Samsung Galaxy
      How to
      Add a New Post in WordPress
      How to
      Copy a QR Code on Android
      How to
      Use Facebook Messenger Bots
      How to
      Store and Read Documents on an iPhone
      6 Simple Steps to Change Your Username in MultiVersus
      3 Ways to Get More Effects on TikTok
      How to
      Use Samsung Pay
      How to
      Turn Off Notifications on PC or Mac
      How to
      Tell Who Has Viewed Your Instagram Story on Android
      How to
      Download Images from Google on PC or Mac
      How to
      Download a Torrent With Android
      How to
      Bump a Post on Facebook
      How to
      Tell if Your Snapchat Message Was Read
      Advertisement

      References

      1. ↑ https://spreadsheeto.com/switch-axis/#how-to

      About this article

      Article Summary X

      1. Open your project in Excel.
      2. Right-click an axis.
      3. Click Select Data .
      4. Click Edit .
      5. Type the data currently in "Series Y Values" in the text field under "Series X Values."
      6. Type the data from "Series X Values" in the text field under "Series Y Values."
      7. Click Ok .

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 23,510 times.

      Is this article up to date?

      Advertisement