How to Switch X and Y Axis in Excel (without changing values)
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Knowing how to switch the x-axis and y-axis in Excel will save you a lot of trouble.
Microsoft Excel is powerful spreadsheet software that will let you store data and make calculations on it. You can then visualize the data using built-in charts and graphs.
However, there are times when you have to switch the value series of the chart’s axes.
And if you don’t know how, your only choice is to exchange the columns or values manually.