JavaScript
google.charts.load('current', {'packages': ['corechart', 'table']});
google.charts.setOnLoadCallback(initialize);
function initialize() {
var query = new google.visualization.Query( 'https://docs.google.com/spreadsheets/d/1vxXJCeuXL2pLrdcxDMGETqLFKazPib4-rHByHh6uQdM/edit?usp=sharing?&range=A1:AI');
query.send(draw);
}
function draw(response) {
if (response.isError()) {
alert('Error in query');
}
var ticketsData = response.getDataTable();
var chart = new google.visualization.ColumnChart(
document.getElementById('chart_div'));
chart.draw(ticketsData, {'isStacked': true, 'legend': 'none', backgroundColor: 'none', 'title': 'Wie viel haben die Löwen in der 3. Staffel zugesagt?', colors: ['#598af0'], 'vAxis': {'title': 'zugesagte Investitionen in Euro'}});
google.visualization.events.addListener(table, 'select',
function() {
map.setSelection(table.getSelection());
});
}
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Director (Year)', 'Investitionen'],
['S1F1', 195000],
['S1F2', 50000],
['S1F3', 240000],
['S1F4', 390000],
['S1F5', 235000],
['S1F6', 240000],
['S1F7', 300000],
['S1F8', 270000],
['S1F9', 0],
['S2F1', 185000],
['S2F2', 300000],
['S2F3', 120000],
['S2F4', 200000],
['S2F5', 400000],
['S2F6', 345000],
['S2F7', 350000],
['S2F8', 410000],
['S2F9', 200000],
['S2F10', 190000],
['S2F11', 440000],
['S3F1', 870000],
['S3F2', 700000],
['S3F3', 150000],
['S3F4', 740000],
['S3F5', 1275000],
['S3F6', 340000],
['S3F7', 775000],
...