Column Types

Column Types are autodetected from the spreadsheet data.

A column type is selected for every column in the Sheet.

Note

As much formatting as possible is removed from number types in order to plot a chart.

Column Types

• Text Text or categorical data
• Integer Whole numbers
• Decimal Numbers with fractions
• Percent Numbers
• Currency Numbers
• Date Dates
• Timestamp Dates with hours/min/seconds
• Year Whole numbers

Tip

Formatting can be re-added to chart numbers via the Number Formatting and Locale options in the Chart Text side panel.