How to Change Axes in Excel

Last Updated: June 18, 2020

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

{"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.
{"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
{"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.
{"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>"}

4
Click Edit . 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.
{"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.
{"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.
{"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>"}

7
Click OK . 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]
  X
  Research source}
Advertisement

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

[1]

How to Change Axes in Excel

Steps

Expert Q&A

You Might Also Like

References

About this article

Is this article up to date?

You Might Also Like

Explore Categories