Google Chart API - Answer

Your client, DataSet Corp, has asked for an interactive web based chart showing the change in revenue from 2005 until now. They would also like the overall average revenue to be reflected in the chart. Be sure to add a title, label axes, and reflect the red and black color scheme used by DSC.

by igalst

HTML

<script src="http://www.google.com/jsapi?ext.js"></script>
<div id="chart"></div>

JavaScript

var json = '[{"1":"120"},{"1":"120","2":"80"},{"1":"120","2":"80","3":"33"},{"1":"120","2":"80","3":"33","4":"33"},{"1":"120","2":"80","3":"33","4":"33","5":"33"},{"1":"120","2":"80","3":"33","4":"33","5":"33","6":"34"},{"1":"120","2":"80","3":"33","4":"33","5":"33","6":"34","7":"31"},{"1":"120","2":"80","3":"33","4":"33","5":"33","6":"34","7":"31","8":"6"},{"1":"120","2":"80","3":"33","4":"33","5":"33","6":"34","7":"31","8":"6","9":"2"},{"1":"120","2":"80","3":"33","4":"33","5":"33","6":"34","7":"31","8":"6","9":"2","10":"2"}]';

function drawChart() {
    json = JSON.parse(json);
    json = json[json.length - 1];

    console.log("json=", json);

    var rows = [];

    for (var week in json) {
        rows.push([parseInt(week), parseInt(json[week])]);
    }

    console.log("rows=", rows);


    var data = new google.visualization.DataTable();
    data.addColumn('number', 'Week');
    data.addColumn('number', 'Signups');
    data.addRows(rows);

    var options = {
        title: 'Signups per week',
        hAxis: {
            title: 'Week'
        },
        vAxis: {
            title: 'Signups'
        }
    };

    var chart = new google.visualization.AreaChart(document.getElementById('chart'));
    chart.draw(data, options);
}

google.load("visualization", "1", {
    packages: ["corechart"]
});
google.setOnLoadCallback(drawChart);