Hi- Im using a spreadsheet to load my data, and the values along the horizontal axis are numerical values 0-48 (representing the number of months passed at that data point. However, the line chart interprets this column not as labels for the horizontal axis, but instead as values and creates another category. Take a look, I'll paste my code below.
Is there a work around to have x-axis values that are numbers, but not charted as values in the chart but rather as labels? <html> <head> </head> <body> <script type="text/javascript" src="http://www.google.com/jsapi";></ script> <script type="text/javascript"> google.load("visualization", "1", {packages:["linechart"]}); google.setOnLoadCallback(drawVisualization); function drawVisualization() { var query = new google.visualization.Query('http:// spreadsheets.google.com/pub?key=rbiiVqXrQZUgJ-ZRnLWXPsw'); query.setQuery('select A, B, C, D, E, F, G'); // Send the query with a callback function. query.send(handleQueryResponse); } function handleQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var data = response.getDataTable(); var chart = new google.visualization.LineChart (document.getElementById('chart_div')); chart.draw(data, {width: 525, height: 450, showCategories: false, legend: 'bottom', title: 'The Great Recession vs. the last five', titleX:'Months from employment peak' , showCategories: true , titleY:'% decline in payroll employment from peak month', backgroundColor: {stroke:null, fill:'#fff', strokeSize: 10}}); } </script> <div id="chart_div"></div> </body> </html> --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
