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

var visualization_Prices_Average;
var visualization_Prices_AverageCountry;
var visualization_Prices_AverageBuyer;


function drawAllFigure() 
{
    drawVisualization_Prices_Average();
	drawVisualization_Prices_AverageCountry();
    drawVisualization_Prices_AverageBuyer();
}

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

function handleQueryResponse_Prices_Average(response) 
{
    if (response.isError()) 
    {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
    }
   
    var data_Prices_Average = response.getDataTable();
    visualization_Prices_Average = new google.visualization.LineChart(document.getElementById('Prices_Average'));
    visualization_Prices_Average.draw(data_Prices_Average, { width: 706, height: 300, legend: "bottom", titleY: "UK pounds", is3D: true });
}


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

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

    var data_Prices_AverageCountry = response.getDataTable();
    visualization_Prices_AverageCountry = new google.visualization.LineChart(document.getElementById('Prices_AverageCountry'));
    visualization_Prices_AverageCountry.draw(data_Prices_AverageCountry, { width: 706, height: 300, legend: "bottom", titleY: "UK pounds",is3D: true });
}

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

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

    var data_Prices_AverageBuyer = response.getDataTable();
    visualization_Prices_AverageBuyer = new google.visualization.LineChart(document.getElementById('Prices_AverageBuyer'));
    visualization_Prices_AverageBuyer.draw(data_Prices_AverageBuyer, { width: 706, height: 300, legend: "bottom", titleY: "UK pounds", is3D: true });
}


google.setOnLoadCallback(drawAllFigure);