You must be logged in to post your query.
Home › Forums › Chart Support › Easiest Google Sheets Integration?
Tagged: sheets
Is there a built-in way to have CanvasJS create a chart using data from a public Google Sheet? For example, the sheet below? https://docs.google.com/spreadsheets/d/18qW3T0LSrqCtg-2JlHSh5cHG06NeHUp4JZUyBg7k1Sw/edit?usp=sharing
If not native, what’s the easiest recommended export?
Many thanks!
@hejenemy,
You can publish Google-Sheet as CSV and use the URL generated to fetch data using jQuery AJAX as shown in this JSFiddle.
— Thangaraj Raman Team CanvasJS
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