Scatter Chart: Swap X and Y Axis

This post will guide you how to swap the X axis and the Y Axis in an existing Scatter Chart in your current worksheet in Excel. How do I quickly switch or flip X and Y Axis in an Excel Scatter chart.
Assuming that you have a set of data that has been created a scatter chart as the following chart.

scatter chart swap x and y1
And you want to switch the X axis and Y axis in this Excel graph. Just do the following steps:

#1 Right click on the scatter chart and then click Select Data from the pop-up menu list.

scatter chart swap x and y2
#2 the Select Data Source window will appear.
#3 select the first Series1 in the Legend Entries section, then click Edit button.

scatter chart swap x and y3
#4 the Edit Series window appear. Then you can copy the Series X values to the Series Y values and vise versa. Click OK button.

scatter chart swap x and y4
#5 if you have two or more Series, just repeat the step 3 and step 4.
#6 let’s see the last result.

scatter chart swap x and y5

Leave a Reply