hi

[sk]

i'm trying to display table,map,pie chart with different database
URLS ,
is there any possibility to do so...

[sk]

i want to draw the column chart and pie chart by using the following
data
https://docs.google.com/spreadsheet/ccc?key=0ArFGfpB6duBGdFBJNVI1c3liaXd0c3l3UVNFMmZoMEE&pli=1#gid=2
can any body help me

[asgallant]

Yes, you can do this.  Your code might look something like:

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

function drawCharts() {
    var query = new google.visualization.Query('https://docs.google.com/spreadsheet/ccc?key=0ArFGfpB6duBGdFBJNVI1c3liaXd0c3l3UVNFMmZoMEE&pli=1#gid=2');
    query.setQuery('put your select statement here');
    query.send(function (response) {
        var data = response.getDataTable();
        
        var column = new google.visualization.ChartWrapper({
            chartType: 'Column',
            dataTable: data,
            containerId: 'column_chart_div',
            options: {
                // chart options here
            },
            view: {
                // define data view here, usually by setting the columns to use, ie:
                columns: [0, 1, 2] // use the first three columns
            }
        });
        column.draw();
        
        var pie = new google.visualization.ChartWrapper({
            chartType: 'Pie',
            dataTable: data,
            containerId: 'pie_chart_div',
            options: {
                // chart options here
            },
            view: {
                // define data view here, usually by setting the columns to use, ie:
                columns: [0, 3] // use the first and fourth columns
            }
        });
        pie.draw();
    });

[sk]

thanku soo much

[asgallant]

You're welcome.