A Waterfall chart that's being created using the Google Sheets connector. In this case only positive values are being displayed.
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.waterfall.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'); for (var i=0; i<labels.length; i+=2) { labels[i] = "\n" + labels[i]; } labels.push('Total'); new RGraph.SVG.Waterfall({ id: 'chart-container', data: data, options: { gutterTop: 50, textSize: 9, xaxisLabels: labels, tooltips: labels, yaxis: false, backgroundGridColor: '#eee', backgroundGridVlines: false, backgroundGridBorder: false, strokestyle: '#aaa', yaxisLabelsCount: 6, xaxisColor: '#333', title: 'Cumulative total of widgets sold by Brian', titleSubtitle: 'Numbers are sales by store only', titleSubtitleItalic: true, labelsAbove: true, labelsAboveUnitsPost: 'pc' } }).draw(); }); </script>