Frequently those improvements come in the form of semi-automated tasks. With each new version of Excel, the capabilities of the program grow. While I have shown an example of a scatter chart in this tutorial, you can use the same steps to switch axis in case of any chart in Excel. How to Change the Intervals on an X-Axis in Excel. So these are two simple and easy ways to switch the axis in Excel charts. Add an entire row or column as a data series: Click its header cell.If the row or column doesn’t have a header cell, drag to select the cells. Also, this way you don’t need to change any data in your sheet. Click the chart, click Edit Data References, then do any of the following in the table containing the data: Remove a data series: Click the dot for the row or column you want to delete, then press Delete on your keyboard. My first column needs to be my X-axis while columns 2, 3, 4 need to be the information that is on my chart (line chart) and the Y-axis.

Switching the axis option in a chart gives you more flexibility for adjusting the chart axis. In this case, you can just move Quantity in column B, and Sales in column C.

The above method works great when you have already created the chart and you want to swap the axis.īut if you haven’t created the chart already, one way could be to rearrange the data so that Excel picks up the data and plots it on the X and Y axis as per your needs.Įxcel by default sets the first column of the data source on the X-axis, and the second column on the Y-axis.

Change axis labels excel 2008 for mac