X-Axis dates not display correctly on charts

This often occurs when X-Axis dates are being calculated by a formula e.g. =today() or when they're coming from another sheet =Sales!A1.

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.

  1. In the example below, the dates in Column A are 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.FAQ_X-axis_dates_don%27t_display
  2. To fix this, copy the dates from Column A, then go to Edit > Paste Special > Paste Values Only to paste them into another column.
  3. To format these as dates, go to Format > Number > Date. Alternatively, you can manually enter the dates.
  4. In Geckoboard, set your Spreadsheets widget to use this new column of dates as the X-Axis of your chart.FAQ_X-Axis_dates_display_answer
Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.