Tuesday, January 31, 2017

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

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

No comments:

Post a Comment