Set column data type

All your data are sorted in a grid of columns and rows. Not only can you 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. There are three types of data you can set for each column of the data: text, number, date.

Set column data type in Chart wizard

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

  1. Below column name, click  to access the dropdown menu.
  2. Choose data type you want to assign to 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 column header or
    Next to column name click the more icon  and click Edit column.
  5. Select new data type from the Data type dropdown.
  6. Click SAVE.

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