Thank you so much! I'm amazed I was that close. When it doesn't work, it
just doesn't work, and I have no idea why.
Billy
On Thursday, October 18, 2012 4:22:58 PM UTC-7, asgallant wrote:
>
> 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/-/rR6xB0-RAcQJ.
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.
