MENU
.net Powerful JavaScript charts
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.

More »

 

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.

More »

Fetching data from Google Sheets or a URL


Posted by lieuwe Montsma at 12:49 on Saturday 8th January 2022 [link]
Am absolutely happy with the RGraph charts.
have 2 questions:
a. var scores = sheet.get('H2:K2'); Can I add a selection criteria as for example:
var scores = sheet.get('H2:K2') where score = 3;
b. can I use an URL variable as the selection criteria? Or use the URL variable as input for a graph?

thax in advance

Leo


Posted by Richard at 15:54 on Saturday 8th January 2022 [link]
a. You can't add selection criteria but you can easily do that with a for() loop after you fetch the data:

var row = sheet.get('H2:K2');

// Change values that aren't 3 to null, and populate a new
 // array (row2) with those values.
 for (var i=0,row2=[]; i<row.length; ++i) {
    if (row[i] !== 3) {
        row[i] = null;
        row2.push(row[i]);
    }
}

b. I don't know your setup so there are two possibilities I can think of. You could get the variable from the URL using server-side scripting (for example PHP). So that would change the above code to:

for (var i=0,row2=[]; i<row.length; ++i) {
    if (row[i] !== <?php echo intval($_GET['myVariable']) ?>) {
        row[i] = null;
        row2.push(row[i]);
    }
}

An example URL would be:

/foo.php?myVariable=3



Another way would be to use JavaScript:

var params = new URLSearchParams(location.search);
var myValue = params.get('myVariable');
    myValue = Number(myValue);

for (var i=0,row2=[]; i<row.length; ++i) {
    if (row[i] !== myValue) {
        row[i] = null;
        row2.push(row[i]);
    }
}

[Replies are closed]