Hi! I have an Excel Spreadsheet with the following data:
Year: 2011 2012
Jan 4802 5178
Feb 4688 5989
Mar 4764 5556
Apr 4813
May 4813
etc.....
I would like to refer to this spreadsheet to create a Google Column
Chart.
Can you please show me the correct code to refer to my Excel
Spreadsheet?
I have created the charts by coding the data in directly:
=======================================
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Month');
data.addColumn('number', '2011');
data.addColumn('number', '2012');
data.addRows([
['Jan', 4802, 5178],
['Feb', 4688, 5989],
['Mar', 4764, 5556],
['Apr', 4813, ],
. . . . .
=======================
But I don't know how to make it refer to the spreadsheet instead.
Thanks!
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
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.
