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.
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:
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:
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:
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:
