How to switch between X and Y axis in scatter chart?
For example, you have created a scatter chart as below screenshot shown. Now you want to switch between the X axis and the Y axis, how could you handle it quickly in Excel? This article will show you an easy solution.
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To switch between the X and Y axis in a scatter chart in Excel, please do as follows:
1. Right-click the scatter chart and click Select Data in the context menu. See screenshot:
2. In the popping out Select Data Source dialog box, please click to highlight the Y column, and then click the Edit button in the Legend Entries (Series) section. See screenshot:
3. Now the Edit Series dialog box comes out. Please swap the Series X values and Series Y values, and then click the OK buttons successively to close both dialog boxes.
Now you will see the X axis and the Y axis are switched in the scatter chart. See screenshot: