I settled on using Google Charts to draw the data from an auto-updating Google Sheet that draws from my Analytics account (the analytic API wasn't working out).
I've done quite a lot of reading, but I'm finding the query language reference to be a pain.
I've chosen to use the ChartWrapper.
https://jsfiddle.net/7xzv59kj/2/
// Visits
var wrap = new google.visualization.ChartWrapper();
wrap.setChartType('ColumnChart');
wrap.setDataSourceUrl('https://docs.google.com/spreadsheets/d/1jICOBDvZzRxEThcWqnpFmNLUqjVP81Zd9RTwpbG29cE/gviz/tq?sheet=Sheet2&range=Keywords-All_Time!B11:C12&headers=1&tq=');
wrap.setContainerId('visits-all-time');
wrap.draw();
}
I want the chart to display the labels for Users and Sessions on the H-Axis, and then the values on the V-Axis. Instead, the data gets all jumbled and confused. I don't know what parameters to specify and how to label them properly.
Spreadsheet located here.
https://docs.google.com/spreadsheets/d/1jICOBDvZzRxEThcWqnpFmNLUqjVP81Zd9RTwpbG29cE
I would like to draw the data from the sheet titled Keywords-All_Time
from range B11:C12