Chart & Visualization Issues

Exchange X and Y Axes in Excel for Mac Charts

Khadija KhanKhadija Khan Nov 14, 2026 868 views

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.

How to Exchange X and Y Axes in Excel for Mac Charts
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.
Before you start

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.

Solution 1Recommended

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.

1
Arrange the data

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.

2
Create the chart

Select the two columns, including their headers, and choose Insert > Scatter (X, Y). Pick the scatter style you want.

3
Verify the series

Select the new chart and open Chart Design > Select Data. Check that the source range and series use the intended X and Y values.

4
Add other series if needed

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.

Rebuild an XY Scatter chart with the X values in the leftmost column
Keep data pairs together: Do not sort or move one column independently of its paired values. If the curves use different quantity values, give each series its own X range.
Create charts in WPS Office

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. 1. Open your workbook: Launch WPS Spreadsheets and open your Excel workbook using File > Open.
  2. 2. Arrange the source data: Place the intended X values in the leftmost column and the paired Y values in the next column.
  3. 3. Insert a scatter chart: Select the data range and choose Insert > Chart, then select an XY Scatter chart.
  4. 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.
Plot numeric X and Y values in an XY Scatter chartOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceCreate and edit charts in a free office suite
QA img-9

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