An SVG Line chart using the Google Sheets connector

You can see the Google Sheet that RGraph is fetching data from here.

This goes in the documents header:

<script src="RGraph.svg.common.core.js"></script>
<script src="RGraph.svg.common.sheets.js"></script>
<script src="RGraph.svg.bar.js"></script>

Put this where you want the chart to show up:

<div style="width: 1000px; height: 300px" id="chart-container"></div>

This is the code that generates the chart:

<script>
    new RGraph.Sheets('1ncvARBgXaDjzuca9i7Jyep6JTv9kms-bbIzyAxbaT0E', function (sheet)
    {
        var data   = sheet.get('B2:B13'),
            labels = sheet.get('A2:A13');
        
        // TODO Carriage returns don't work yet
        for (var i=0; i<labels.length; i+=2) {
            labels[i] = "\n" + labels[i];
        }

        new RGraph.SVG.Line({
            id: 'chart-container',
            data: data,
            options: {
                hmargin: 0,
                xaxisLabels: labels,
                gutterRight: 45
            }
        }).draw();
    });
</script>

« Back