This often occurs when X-Axis dates are being calculated by a formula e.g.
=today() or when they're sourced from another sheet
Unfortunately our Spreadsheets data source cannot display these dates due to a limitation of the Google Sheets API. When the data comes through the API into Geckoboard, it's no longer recognized as a date.
We recommend to create another column with manually entered dates that Geckoboard will use to populate your charts.
In the example below, the dates in Column
Aare coming from another Google Sheet. This means our Spreadsheets data source isn't able to display these dates in the X-Axis of the chart.
To fix this, copy the dates from Column
A, then go to Edit > Paste Special > Paste Values Only to paste them into another column.
To format these as dates, go to Format > Number > Date. Alternatively, you can manually enter the dates.
In Geckoboard, set your Spreadsheets widget to use this new column of dates as the X-Axis of your chart.