Show All

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.

   How?

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.