Add and delete rows in data grid
All your data are sorted in a grid of columns and rows. Of course, you can customize the data in the existing columns and rows, but you can also add new or delete columns and rows.
Data for charts with the auto option update can’t be changed within the data grid.
Add a new row
-
Open the chart you want to edit.
-
In the upper-right corner, click Edit.
-
In the bottom-right corner, click DATA.
Add row between existing rows
- On the left, click the more icon next to row number.
- Click insert (above or below).
Add row at the end of the grid
- Go to the last row.
- On the far left side of the grid, click + .
You can drag and drop rows to reorder them.
Delete a row
-
Open the chart you want to edit.
-
In the upper-right corner, click Edit.
-
In the bottom-right corner, click DATA.
-
Hover over the row number and click on the checkboxes to select one or more rows you want to delete. Then click on the more icon .
- Click Delete row if you select a single row or click Delete selected rows for multiple selected rows.
To select all rows, click one of the checkboxes, and then the checkbox in the top-left corner of the data grid so apply the selection.