Change the values plotted on the x-axis

For line charts or column charts

1. In the Chart Properties, select the Data page.

2. Under Category Properties/Select Grouping for X-Axis, select the required data field or expression that you want to plot on the x-axis.

This expression is used both to group the data and to label the x-axis. The expression may return string values or numeric values.

3. Save the settings.

For scatter charts and bubble charts

1. In the Chart Properties, select the Data page.

2. Under Data Values/Select X-Value, select the required data field or expression that you want to plot on the x-axis (typically a numeric value).

3. Save the settings.