I have a slight problem with my row labels not displaying properly. Here's my line graph pulling data from a Google Spreadsheet:
http://www.housingandneighbourhoods.org.uk/analysis.html http://spreadsheets.google.com/ccc?key=p55MjbBJ0omRe_WtN6D7PCg# The problem is that column 1 shouldn't be displayed on the graph but instead should be the labels for each row of data and display along the x-axis. Am I missing something really obvious? Here's the basic JavaScript: google.load("visualization", "1", {packages: ["table", "map", "columnchart", "barchart", "linechart"]}); google.setOnLoadCallback(initialize); function initialize() { // The URL of the Google spreadsheet for the data var query = new google.visualization.Query('http:// spreadsheets.google.com/pub?key=p55MjbBJ0omRe_WtN6D7PCg'); query.send(draw); } function draw(response) { if (response.isError()) { alert("Error in query") } var jrfNationalData = response.getDataTable(); var chart = new google.visualization.LineChart(document.getElementById ('chart_div')); chart.draw(jrfNationalData, {width: 600, height:400, 'legend': 'bottom', 'title': 'Key Economic Trends', 'titleX': 'Year', 'titleY': '%'}); } 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 -~----------~----~----~----~------~----~------~--~---
