Adjusting data series
After you create a chart, you can adjust the data range. You can swap X/Y axis, enter/modify the data, and add/remove the rows/columns.
To adjust the data range, double-click the relevant chart, or in the shortcut menu, select Chart properties. In the Values tab of the Chart Properties dialog box, adjust the data range.
Insert a row and enter the data
- Double-click the relevant chart, or in the shortcut menu, select Chart properties.
- In the Values tab of the Chart Properties dialog box, place your mouse pointer on the title of a row, and right-click to open the shortcut menu. Select Insert Rows.
- Double-click a cell of the inserted row, and enter the data. You can also enter the data in the Value.
- In the Chart preview, confirm the chart appearance, and click OK.
If you click Swap X/Y Axis, the X-axis and the Y-axis will be switched. You can delete rows and columns in the shortcut menu by selecting Delete Rows or Delete Columns.