google.load('visualization', '1', { packages: ['linechart', "barchart", "columnchart"] });

var visualization_Eco_Trends;
var visualization_Eco_BusinessSurv;
var visualization_Eco_Productivity;
var visualization_Eco_Savings;

function drawAllFigure() 
{
    drawVisualization_Eco_Trends();
    drawVisualization_Eco_BusinessSurv();
    drawVisualization_Eco_Productivity();
    drawVisualization_Eco_Savings();
	
}

//Eco_Trends
function drawVisualization_Eco_Trends() 
{
    // To see the data that this visualization uses, browse to
    var query_Eco_Trends= new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Eco_Trends');
    // Send the query with a callback function.
    query_Eco_Trends.send(handleQueryResponse_Eco_Trends);
}

function handleQueryResponse_Eco_Trends(response) 
{
    if (response.isError()) 
    {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }
   
    var data_Eco_Trends = response.getDataTable();
    visualization_Eco_Trends = new google.visualization.LineChart(document.getElementById('Eco_Trends'));
    visualization_Eco_Trends.draw(data_Eco_Trends, { width: 706, height: 300, legend: "bottom", titleY: "Percentage (%)", is3D: true });
}


// Eco_BusinessSurv
function drawVisualization_Eco_BusinessSurv() 
{
    // To see the data that this visualization uses, browse to
    var query_Eco_BusinessSurv = new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Eco_BusinessSurv');
    // Send the query with a callback function.
    query_Eco_BusinessSurv.send(handleQueryResponse_Eco_BusinessSurv);
}

function handleQueryResponse_Eco_BusinessSurv(response) {
    if (response.isError()) {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }

    var data_Eco_BusinessSurv = response.getDataTable();
    visualization_Eco_BusinessSurv = new google.visualization.ColumnChart(document.getElementById('Eco_BusinessSurv'));
    visualization_Eco_BusinessSurv.draw(data_Eco_BusinessSurv, { width: 706, height: 300, legend: "bottom", titleY: "GVA per Hour Worked", is3D: true });
}


// Eco_Productivity
function drawVisualization_Eco_Productivity() {
    // To see the data that this visualization uses, browse to
    var query_Eco_Productivity = new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Eco_Productivity');
    // Send the query with a callback function.
    query_Eco_Productivity.send(handleQueryResponse_Eco_Productivity);
}

function handleQueryResponse_Eco_Productivity(response) {
    if (response.isError()) {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }

    var data_Eco_Productivity = response.getDataTable();
    visualization_Eco_Productivity = new google.visualization.ColumnChart(document.getElementById('Eco_Productivity'));
    visualization_Eco_Productivity.draw(data_Eco_Productivity, { width: 706, height: 300, legend: "bottom", titleY: "Percentage (%)", is3D: true });
}

//Eco_Savings
function drawVisualization_Eco_Savings() 
{
    // To see the data that this visualization uses, browse to
    var query_Eco_Savings = new google.visualization.Query(
          'https://spreadsheets.google.com/pub?key=0Am-mi-Fc5ks5dG5Mc2kzQ2I2VnNETFJwQl85VlVzWVE&sheet=Eco_Savings');
    // Send the query with a callback function.
    query_Eco_Savings.send(handleQueryResponse_Eco_Savings);
}

function handleQueryResponse_Eco_Savings(response) 
{
    if (response.isError()) 
    {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }
   
    var data_Eco_Savings = response.getDataTable();
    visualization_Eco_Savings = new google.visualization.ColumnChart(document.getElementById('Eco_Savings'));
    visualization_Eco_Savings.draw(data_Eco_Savings, { width: 706, height: 600, legend: "bottom", titleY: "Percentage (%)", is3D: true, min: "0", isStacked: true, max: "100" });
}



google.setOnLoadCallback(drawAllFigure);