Editing columns

All your data is organized in a grid of columns and rows. You can not only edit the data itself, but also adjust grid properties such as column names and data types.

Change column name

1. In the chart panel, click DATA in the bottom-right corner to open the data grid.
2. Double-click the column header, or click the more icon more_vert next to the column name and select Edit column.
3. Click the Column field and enter the new name.
4. Click Save.

Set column default value

In addition to importing data, Charts allows you to enter data manually. When working with repetitive values, the Default value option helps you avoid entering the same value multiple times.

Set default value for new columns

1. In the chart panel, click DATA in the bottom-right corner to open the data grid.
2. Click the create column icon add next to the last column.
3. In the Default value field, enter the value to be automatically added to all new rows.

Set default value for existing columns

When setting a default value for an existing column, it will apply only to new rows added after the change. Existing rows will remain unchanged.

1. In the chart panel, click DATA in the bottom-right corner to open the data grid.
2. Double-click the column header, or click the more icon more_vert and select Edit column.
3. In the Default value field, enter the value for new rows.

Set column data type

Each column can be assigned one of three data types: Text, Number, or Date.

• Text – Use for textual data points. Keep letter casing consistent for uniformity.
• Number – Use for numerical values, and watch out for outliers. Avoid formatting like percentages or currency, since most spreadsheet formatting is ignored by Vizualist Chart. Decimals are supported, and you can specify the number of decimal places in the data file before uploading.
• Date – Use for time intervals such as years, quarters, months, days, hours, or minutes. Pay close attention to the format — Vizualist Chart requires date data in a specific format to recognize it.

Set column data type when uploading data

After uploading data, Charts automatically detects column types, but you can adjust them during the data review step.

1. Below the column name, click arrow_drop_down to open the dropdown menu.
2. Select the data type you want to assign to the column.

Set column data type in data grid

1. In the chart panel, click DATA in the bottom-right corner to open the data grid.
2. Double-click the column header, or click the more icon more_vert and select Edit column.
3. Select a new data type from the Data type dropdown.
4. Click Save.

Sort column values in data grid

As you add more data to your chart, organizing it becomes increasingly important. Depending on the data type, you can sort the values in each column.

1. In the chart panel, click DATA in the bottom-right corner to open the data grid.
2. Double-click the column header, or click the more icon more_vert next to the column name.
3. Select the sorting option you want to apply.

Add new column

In addition to editing existing data, you can also add or duplicate a column.

1. In the chart panel, click DATA in the bottom-right corner to open the data grid.
2. Next to the last column, click the add icon add to add a new column.

3. Enter the column details and click Create.

   Note: If you don't want the column to be added as a series (for example, when using the "Grouping" option), uncheck the Add column as series option.

4. Fill in the column data or copy and paste it from your external source.

Duplicate column

1. In the chart panel, click DATA in the bottom-right corner to open the data grid.
2. Next to the column name, click the more icon more_vert.
3. Click Duplicate.

Delete column

1. In the chart panel, click DATA in the bottom-right corner to open the data grid.
2. Next to the column name, click the more icon more_vert.
3. Click Delete.