Exchange X and Y Axes in Excel for Mac Charts
Question details
The user wants to exchange the X and Y variables in an Excel for Mac chart, such as a supply-and-demand chart.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A chart needs to display the intended independent variable on the horizontal axis and the other variable on the vertical axis.
- Observed behavior
- Instructions for switching axes in other Excel versions may not match the controls available in Excel for Mac.
Select the chart and check its type under Chart Design > Change Chart Type. For numeric X and Y variables, use an XY Scatter chart and identify the source ranges for each variable.
Rebuild an XY Scatter chart with the X values in the leftmost column
Use this method when you want to swap numeric variables and the existing chart's series controls are unclear.
An XY Scatter chart plots numeric X and Y values. For a supply-and-demand chart, this often means plotting quantity on the X-axis and price on the Y-axis.
In the worksheet, place the intended X values in the leftmost column and the corresponding Y values in the next column. Keep each X and Y pair on the same row.
Select the two columns, including their headers, and choose Insert > Scatter (X, Y). Pick the scatter style you want.
Select the new chart and open Chart Design > Select Data. Check that the source range and series use the intended X and Y values.
In Chart Design > Select Data, add or edit a series for each additional curve. For supply and demand, assign each curve its corresponding quantity X values and price Y values.

Edit the X and Y ranges of an existing scatter series
Use this method to update an existing XY Scatter chart without recreating it.
Create an XY Scatter Chart in WPS Spreadsheets
Use WPS Spreadsheets to arrange your X and Y data and create a scatter chart with the variables on the intended axes.
- 1. Open your workbook: Launch WPS Spreadsheets and open your Excel workbook using File > Open.
- 2. Arrange the source data: Place the intended X values in the leftmost column and the paired Y values in the next column.
- 3. Insert a scatter chart: Select the data range and choose Insert > Chart, then select an XY Scatter chart.
- 4. Check the axes: Inspect the chart to confirm that the horizontal axis shows the intended X values and the vertical axis shows the intended Y values. Update the axis titles as needed.

Frequently Asked Questions
Does Switch Row/Column swap the X and Y axes?
Not usually. Chart Design > Switch Row/Column changes which rows or columns are treated as series. To exchange numeric X and Y variables, edit the series ranges or rebuild an XY Scatter chart.
Which chart type should I use for a supply-and-demand graph?
Use Insert > Scatter (X, Y) when both quantity and price are numeric. Assign quantity to each series' X values and price to its Y values.
Can supply and demand use different X-value ranges?
Yes. In an XY Scatter chart, each series can have its own X and Y ranges. Use Chart Design > Select Data to add or edit the supply and demand series separately.
What if I cannot find the X and Y value fields on my Mac?
Arrange the intended X values in the leftmost column and their paired Y values next to them, then select the data and create a new chart with Insert > Scatter (X, Y).




