FIXED: A Line chart using the Google Sheets connector - Official support forum

About

RGraph is a JavaScript charts library based on HTML5 SVG and canvas. RGraph is mature (over 18 years old) and has a wealth of features making it an ideal choice to use for showing charts on your website.

Version 7.20

Version 7.20 (released in June 2026) is the latest version of RGraph and the major change in this version is an update to the default values of properties making for better looking charts without having to set any properties. Read more about this and other changes in the changelog.

Download »

Download

Get the latest version of RGraph (version 7.20, 9th June 2026) from the download page. You can read the changelog here. There's also older versions available, minified files and links to cdnjs.com hosted libraries.

Download »

Latest forum posts

These are the latest support forum posts that have been posted or updated.

16th June, Rachel
I have a question about the 3D Bar chart

12th June, Marco
Should I use SVG or canvas for the charts on my website?

9th June, Richard
New version of RGraph: version 7.20

3rd June, Patrick
Question about installing RGraph

1st June, Ouja
How do I add a click event to a bar in my Bar chart?

Support forum »

License

RGraph can be used for free under the GPL or if that doesn't suit your situation there's an inexpensive (£129) commercial license available.

A Line chart using the Google Sheets connector

I have a problem with displaying a line chart using Google sheets connector. I have set visibility for everyone in the settings for the table and in the Data Studio too. I was able to locate the sheet identificator and I was able to post a chart on my web when linking a demo chart from this site. As soon as I try to link any other chart using any table in my own accounts I have made in Google, it does not work. The files sit in my Google drives and I am sharing them with everybody with the link. I also found the table used in the demo just by altering my own links the way I replaced the identificator. So I could see the tables looked very similar to mine. My question is: what everything needs to be set in the Google account for my charts to be visible on my websites? I have never used Data Studio or data sources saved in Google drive. Thank you in advance for any replies. :)

The Google Sheets connector is only designed to work with spreadsheets that are created and accessed using the Google Sheets online application.

It won't work with things that are saved in your Google Drive or in Data Studio.

What is the ID/key of your spreadsheet? It should look a bit like the one for the example spreadsheet that the RGraph website uses:

1ncvARBgXaDjzuca9i7Jyep6JTv9kms-bbIzyAxbaT0E

So the code for that would look like this:

new RGraph.Sheets('1ncvARBgXaDjzuca9i7Jyep6JTv9kms-bbIzyAxbaT0E', function (sheet)
{
// Make the chart here
});