Google Sheet decimal separator

Data Sources

If your Google Sheet uses a comma for the decimal separator, you may find that percentages are not accurately being brought in Chartio. The issue is that Chartio expects the decimal separator to be a dot.

By opening your Google Sheet and changing the locale of your spreadsheet (File > Spreadsheet settings) to for example, United States, it will change the decimal separator to a dot. This will allow Chartio to detect the column as the correct percentage value.


Related Data Sources Help Articles

See more