Trying to get the following code to run and allow for the display of
multiple "Regions" (i.e. last column).
Only "Region 6" displays in the motionchart. I see that this has been
addressed in previous discussions but the current motionchart
documentation indicates that columns 4 and above can be string or
numeric.
Any thoughts?
<script type="text/javascript" src="
http://www.google.com/jsapi"></
script>
<script type="text/javascript">
google.load('visualization', '1', {packages: ['motionchart']});
function drawVisualization() {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Category');
data.addColumn('number', 'Year');
data.addColumn('number', 'Count');
data.addColumn('string', 'Region');
data.addRows([
['Founded',2004,1291,'Region 1'],
['Founded',2004,970,'Region 2'],
['Founded',2004,1481,'Region 3'],
['Founded',2004,1227,'Region 4'],
['Founded',2004,1018,'Region 5'],
['Founded',2004,1662,'Region 6'],
['Founded',2005,1476,'Region 1'],
['Founded',2005,1248,'Region 2'],
['Founded',2005,1511,'Region 3'],
['Founded',2005,1033,'Region 4'],
['Founded',2005,1039,'Region 5'],
['Founded',2005,1538,'Region 6'],
['Founded',2006,1472,'Region 1'],
['Founded',2006,1205,'Region 2'],
['Founded',2006,1353,'Region 3'],
['Founded',2006,1167,'Region 4'],
['Founded',2006,1018,'Region 5'],
['Founded',2006,1508,'Region 6'],
['Founded',2007,1419,'Region 1'],
['Founded',2007,1263,'Region 2'],
['Founded',2007,1300,'Region 3'],
['Founded',2007,1269,'Region 4'],
['Founded',2007,951,'Region 5'],
['Founded',2007,1180,'Region 6'],
['Founded',2008,1394,'Region 1'],
['Founded',2008,1008,'Region 2'],
['Founded',2008,1285,'Region 3'],
['Founded',2008,1188,'Region 4'],
['Founded',2008,1107,'Region 5'],
['Founded',2008,1128,'Region 6'],
['Inconclusive',2004,2484,'Region 1'],
['Inconclusive',2004,1830,'Region 2'],
['Inconclusive',2004,3485,'Region 3'],
['Inconclusive',2004,2821,'Region 4'],
['Inconclusive',2004,2116,'Region 5'],
['Inconclusive',2004,3418,'Region 6'],
['Inconclusive',2005,2151,'Region 1'],
['Inconclusive',2005,1539,'Region 2'],
['Inconclusive',2005,3175,'Region 3'],
['Inconclusive',2005,2443,'Region 4'],
['Inconclusive',2005,2112,'Region 5'],
['Inconclusive',2005,2915,'Region 6'],
['Inconclusive',2006,2352,'Region 1'],
['Inconclusive',2006,1382,'Region 2'],
['Inconclusive',2006,2541,'Region 3'],
['Inconclusive',2006,2611,'Region 4'],
['Inconclusive',2006,1961,'Region 5'],
['Inconclusive',2006,3111,'Region 6'],
['Inconclusive',2007,2533,'Region 1'],
['Inconclusive',2007,1222,'Region 2'],
['Inconclusive',2007,2255,'Region 3'],
['Inconclusive',2007,2661,'Region 4'],
['Inconclusive',2007,2016,'Region 5'],
['Inconclusive',2007,2566,'Region 6'],
['Inconclusive',2008,2024,'Region 1'],
['Inconclusive',2008,861,'Region 2'],
['Inconclusive',2008,2063,'Region 3'],
['Inconclusive',2008,2249,'Region 4'],
['Inconclusive',2008,1723,'Region 5'],
['Inconclusive',2008,1799,'Region 6'],
['No Finding',2004,461,'Region 1'],
['No Finding',2004,327,'Region 2'],
['No Finding',2004,847,'Region 3'],
['No Finding',2004,600,'Region 4'],
['No Finding',2004,324,'Region 5'],
['No Finding',2004,476,'Region 6'],
['No Finding',2005,214,'Region 1'],
['No Finding',2005,112,'Region 2'],
['No Finding',2005,453,'Region 3'],
['No Finding',2005,399,'Region 4'],
['No Finding',2005,158,'Region 5'],
['No Finding',2005,193,'Region 6'],
['No Finding',2006,151,'Region 1'],
['No Finding',2006,107,'Region 2'],
['No Finding',2006,95,'Region 3'],
['No Finding',2006,391,'Region 4'],
['No Finding',2006,81,'Region 5'],
['No Finding',2006,135,'Region 6'],
['No Finding',2007,137,'Region 1'],
['No Finding',2007,107,'Region 2'],
['No Finding',2007,128,'Region 3'],
['No Finding',2007,340,'Region 4'],
['No Finding',2007,128,'Region 5'],
['No Finding',2007,94,'Region 6'],
['No Finding',2008,221,'Region 1'],
['No Finding',2008,73,'Region 2'],
['No Finding',2008,126,'Region 3'],
['No Finding',2008,459,'Region 4'],
['No Finding',2008,234,'Region 5'],
['No Finding',2008,113,'Region 6'],
['Unfounded',2004,1872,'Region 1'],
['Unfounded',2004,1638,'Region 2'],
['Unfounded',2004,2212,'Region 3'],
['Unfounded',2004,2563,'Region 4'],
['Unfounded',2004,2218,'Region 5'],
['Unfounded',2004,2195,'Region 6'],
['Unfounded',2005,2598,'Region 1'],
['Unfounded',2005,1966,'Region 2'],
['Unfounded',2005,3852,'Region 3'],
['Unfounded',2005,3537,'Region 4'],
['Unfounded',2005,2868,'Region 5'],
['Unfounded',2005,3208,'Region 6'],
['Unfounded',2006,2401,'Region 1'],
['Unfounded',2006,2036,'Region 2'],
['Unfounded',2006,3716,'Region 3'],
['Unfounded',2006,3904,'Region 4'],
['Unfounded',2006,2783,'Region 5'],
['Unfounded',2006,2679,'Region 6'],
['Unfounded',2007,2649,'Region 1'],
['Unfounded',2007,2042,'Region 2'],
['Unfounded',2007,3690,'Region 3'],
['Unfounded',2007,4159,'Region 4'],
['Unfounded',2007,2624,'Region 5'],
['Unfounded',2007,2442,'Region 6'],
['Unfounded',2008,3115,'Region 1'],
['Unfounded',2008,2519,'Region 2'],
['Unfounded',2008,4061,'Region 3'],
['Unfounded',2008,4985,'Region 4'],
['Unfounded',2008,3331,'Region 5'],
['Unfounded',2008,2901,'Region 6']
]);
var motionchart = new google.visualization.MotionChart(
document.getElementById('visualization'));
motionchart.draw(data, {'width': 800, 'height': 400});
}
google.setOnLoadCallback(drawVisualization);
</script>