Can you please create a public copy of your spreadsheet so that I can examine your data within
Thanks ChartMan On Thu, May 17, 2012 at 12:31 PM, sindhu <[email protected]> wrote: > *i plotted a geomap with static data as * > > Google.load('visualization', '1', {packages: ['geomap']}); > > function drawVisualizationMap() { > var data = new google.visualization.DataTable(); > data.addColumn('string', 'State'); > data.addColumn('number', 'SEZ'); > data.addRows([ > ['Andhra pradesh',13052.9048], > ['Chandigarh',58.4566], > ['Chattisgarh',111.77], > ['Dadra & Nagar Haveli',11.465], > ['Delhi',33.25], > ['Goa',369.98], > ['Gujarat',16675.0032], > ['Haryana',1764.567], > ['Jharkand',36], > ['Karnataka',2974.2899], > ['Kerala',1149.5487], > ['Madhya Pradesh',848.371], > ['Maharashtra',12037.0748], > ['Nagaland',450], > ['orissa',2048.076], > ['Pondicherry',346], > ['punjab',215.132], > ['Rajasthan',584.4905], > ['Tamil Nadu',6538.3858], > ['Uttar Pradesh',985.8126], > ['Uttranchal',440], > ['West Bengal',444.517] > ]); > var geoMap = new > google.visualization.GeoMap(document.getElementById('visualization')); > geoMap.draw(data, {width: 1150, height: 800, region: 'IN', > resolution: 'provinces' }); > } > google.setOnLoadCallback(drawVisualizationMap); > > *i did same with actual data which is in spreadsheet of Google doc's as* > * var visualization;* > > function drawVisualization() { > > var query = new google.visualization.Query( > ' > https://docs.google.com/spreadsheet/ccc?key=0ArFGfpB6duBGdDM3ZzdsQjlQdWxxQjVndlpRZTNzekE#gid=0' > ); > > // Send the query with a callback function. > query.send(draw); > } > > function draw(response) { > if (response.isError()) { > alert('Error in query'); > } > > var map = response.getDataTable(); > var geo = new > google.visualization.GeoMap(document.getElementById('geomap_id')); > geo.draw(map, {width: 1150, height: 800, region: 'IN', > resolution: 'provinces' }); > > } > > > google.setOnLoadCallback(drawVisualization); > > > *the problem i'm facing is it showing an error as* > > The columns type does not match the supported data format. See > documentation for supported formats. > > *plz help me,if there are any error's in the code* > > -- > 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. > -- 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.
