You must be logged in to post your query.
Home › Forums › Chart Support › Easiest Google Sheets Integration?
Is there a built-in way to have CanvasJS create a chart using data from a public Google Sheet? For example, the sheet below?
If not native, what’s the easiest recommended export?
You can publish Google-Sheet as CSV and use the URL generated to fetch data using jQuery AJAX as shown in this JSFiddle.
Thank you. Is there any guidance on how to manipulate the data? The example is a very simple series, just a few data points in a column. How would you specify specific columns in the Google Sheet to correspond with the axis or data series within the CanvasJS chart?
You can read a specific row from the CSV file by its index / header. Please take a look at this documentation page for a step-by-step tutorial on rendering charts with data from a CSV file and parsing it. Also, please refer to this article for more information on parsing CSV data.
You must be logged in to reply to this topic. Login/Register