Edit column

All your data is sorted into a grid of columns and rows. Not only you can edit the data in the grid, but you can also change the properties of the grid itself such as the type of data in each column and the names of columns.

Editing data is impossible for charts with the auto-update option turned on.

Change column name

  1. Open the chart you want to edit.

  2. In the upper-right corner, click EDIT.

  3. In the bottom-right corner, click DATA.

  4. Double-click on the column header or next to the column name click the more icon and then click Edit column.

  5. Click the Column field to edit the name.

  6. Click SAVE.

Set column default value

In addition to importing data, Charts allows you to manually enter data as well. This can become quite strenuous, especially when dealing with larger datasets or identical values. When dealing with identical values, Default value comes in handy. Here's how to avoid adding the same value multiple times.

Set default value for new columns

  1. Open the chart you want to edit.

  2. In the upper-right corner, click EDIT.

  3. In the bottom-right corner, click DATA.

  4. Go to the last column.

  5. Next to the last column click the Create column icon .

  6. In the Default value field, enter the value you want to be added to all new rows in that column.

The default value will be added to all the rows in the new column.

Set default value for existing columns

When setting default values for existing columns, bear in mind that the default value will be added only to the rows you add after you set the default value. All rows you added before setting the default value, even if blank, will remain unchanged.

  1. Open the chart you want to edit.

  2. In the upper-right corner, click EDIT.

  3. In the bottom-right corner, click DATA.

  4. Double-click on the column header or next to the column name click the more icon and then click Edit column.

  5. In the Default value field, enter the value you want to be added to all new rows in that column.

Set column data type

There are three types of data you can set for each column of the data: Text, Number, and Date.

Set column data type in Chart wizard

After uploading data, Charts will identify the data type for all columns in the dataset, but you can change column data type during data review.

  1. Below the column name, click to access the dropdown menu.

  2. Choose the data type you want to assign to that column.

Set column data type in data grid

  1. Open the chart you want to edit.

  2. In the upper-right corner, click EDIT.

  3. In the bottom-right corner, click DATA.

  4. Double-click on the column header or next to the column name click the more icon and then click Edit column.

  5. Select a new data type from the Data type dropdown menu.

  6. Click SAVE.

    7. Converting data type may clear some cell data. This cannot be undone.