echo $chart; $dataView = new Google_Data_View(); $dataView->setViewTable("dataView1"); $dataView->setDataTable($dataTable); $dataView->setColumns(array(0, 2)); echo $dataView; $chart2 = new Google_Chart("Table", $dataVar2); $chart2->draw($dataView, $options); echo $chart2; $dataView2 = new Google_Data_View(); $dataView2->setViewTable("dataView2"); $dataView2->setDataTable($dataTable); $dataView2->setColumns(array(0, 1, 3)); echo $dataView2; $chart3 = new Google_Chart("Table", $dataVar3); $chart3->draw($dataView2, $options); echo $chart3; ?> } google.setOnLoadCallback(drawVisualization); </script> </head> <body style="font-family: Arial;border: 0 none;"> <div>Original Data Table</div> <div id="table1"></div> <br /> <div>A Data View</div> <div id="table2"></div> <br /> <div>Another Data View</div> <div id="table3"></div>
$chartType = 'AreaChart'; $query = 'SELECT A,D WHERE D > 100 ORDER BY D'; } $id = 'viz'; $url = 'http://spreadsheets.google.com/tq?key=pCQbetd-CptGXxxQIG7VFIQ&pub=1'; # new visualization using template default $v = new Google_Visualization("Default"); # register package $p = new Google_Package(array("packages" => array($chartType), "language" => "de_DE")); $v->setPackage($p); // set package object to visualization # setup chart $chart = new Google_Chart($chartType, Google_Base::getElementById($id)); $options = new Google_Config($chartType); $options->setProperty("width", 550); $chart->draw("data", $options); # init functions $f1 = new Google_Function('drawVisualization'); $f2 = new Google_Function('handleQueryResponse', array('response')); # setup query $q = new Google_Data_Query($url); $q->setQuery($query); $q->send($f2->getName()); $f1->add($q); $f1->setCallBack(); $v->setFunction($f1); # setup response $qr = new Google_Data_QueryResponse(); $qr->asVar($chart->getDataTable())->getDataTable(); $f2->add($qr->render(true)); $chart->setDataTable("visualization");