You almost had it. Just two things:
1) the flip number value you want is in (0, 0) in the data, not (1, 1)
2) you needed to put the line document.getElementById('flipnumbers'
).innerHTML = flipNumber; in the script after you assign the value to
flipNumber
See it working here: http://jsfiddle.net/asgallant/XdHD8/
On Thursday, October 18, 2012 7:14:46 PM UTC-4, Billy Bones wrote:
>
> Thanks for your help ASG, I am not getting anywhere, can you tell me what
> I'm doing wrong here trying to implement your idea.
>
> <!DOCTYPE html>
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"
> ></meta>
> <title>Home Page</title>
> <!--Load the AJAX API-->
> <script type="text/javascript" src="http://www.google.com/jsapi";>
> </script>
> <script type="text/javascript">
> //Load the Visualization API and the ready-made Google table
> visualization
> google.load('visualization', '1', {'packages':['corechart']});
> </script>
>
> <script type='text/javascript'>
>
> function drawA() {
> // Define the chart using setters:
> var wrap = new google.visualization.ChartWrapper();
> wrap.setChartType('PieChart');
> wrap.setDataSourceUrl('
> https://docs.google.com/spreadsheet/ccc?key=0ArzcNGBduYipdDFLMGM1SEZ1ZVhWdHUyOEl3QmRodEE#gid=0
> ');
> wrap.setContainerId('numberofclients');
> wrap.setOptions({'title':'Number of Clients','width':410,
> 'height':310,'chartArea':{width:"90%",height:"100%"}});
> wrap.draw();
> wrap.getChart();
> }
>
> function drawB() {
> var query = new google.visualization.Query('
> https://docs.google.com/spreadsheet/ccc?key=0ArzcNGBduYipdDc3VUtSQUQ4dUNRdnVRZUYzTGRjZVE&range=A1
> ');
> query.send(function (response) {
> if (response.isError()) {
> alert('Error in query: ' + response.getMessage() + ' ' +
> response.getDetailedMessage());
> return;
> }
>
> var data = response.getDataTable();
> var flipNumber = data.getValue(1, 1);
> });
> }
>
> function drawVisualization() {
> drawA();
> drawB();
> }
>
>
> google.setOnLoadCallback(drawVisualization);
> </script>
> </head>
> <body>
> <a href="http://www.wardell.biz/pelican";>Are you a Pelican, or a
> Peli-can't?</a>
> <div id="container" style="width:1300px;height:455px;">
> <div style="position:relative;width:100%">
>
> <div id="clientnumbers" onclick="location.href='
> http://www.wardell.biz/billyclients';"style="cursor:pointer;
> position:absolute;left:10px;top:0px;border:5px black
> solid;border-radius:25px;
> -moz-border-radius:25px;height:420px;width:500px;padding:6px;">
> <div id="numberofclients"; onclick="location.href='
> http://www.wardell.biz/billyclient1';"style="cursor:pointer;
> position:relative;left:6px;top:10px;height:220px;width:410px;"></div>
>
>
>
> </div>
> <div id="flipnumbers"style="cursor:pointer;
> position:absolute;left:550px;border:5px red solid;border-radius:25px;
> -moz-border-radius:25px;height:420px;width:500px;padding:6px">
> <document.getElementById('flipnumbers').innerHTML = flipNumber;>
> </div>
>
> </div>
>
> </div>
>
> </body>
> </html>
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/RpPwmNRB5SkJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
