Change which row or column contains the x axis values for an xy (scatter) chart

You can change the data series whose values are used to calculate tick-mark labels along the x axis in an xy (scatter) chart. By default, the values in the first series on the datasheet are used for tick-mark labels. An "X" appears in the row or column heading next to the data series you have assigned to be plotted on the x axis.

  1. Switch to the datasheet.


  2. Click the row heading or column heading of the row or column you want to use as the values along the x axis.

  3. On the Data menu, click Plot on X Axis.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.