I just noticed the custom tooltips from the google spreadsheet do not work. How can I get them to work with what you were able to show me to do with custom colors for each bar?
Thanks for the help beforehand Asgallant! On Wednesday, January 9, 2013 11:52:26 AM UTC-9, Justawebbie wrote: > > Thank you so much Asgallant, that really helped me to see what I did wrong > and it is nice. > > Take care and again thank you for your help. > > > > On Tuesday, January 8, 2013 2:37:54 PM UTC-9, asgallant wrote: >> >> To get the tooltips, you have to include the tooltip column after every >> data column in the view. Also, if you are looking for different colors for >> each bar, you might be better off assigning data to columns by name rather >> than by value (example here: http://jsfiddle.net/asgallant/zwPuU/). >> Here's an example using your code as the base: >> http://jsfiddle.net/asgallant/JENzE/ >> >> On Tuesday, January 8, 2013 5:23:25 PM UTC-5, Justawebbie wrote: >>> >>> I know this is just me getting myself confused as I read all the >>> different ways everyone is doing this. I am trying to color each column a >>> different color and use tooltips all coming from a google spreadsheet. I >>> have tried doing isStacked with 0's in the other columns which worked but >>> my tooltips stopped working for the 2 of the 3 columns. I then went back >>> to the drawing board so now I am stuck. I think I just have this a bit off >>> in coding or I am way off base on it. Thanks in advance for any help you >>> give to this newby. >>> >>> var visualization; >>> >>> function drawVisualization() { >>> var query = new google.visualization.Query( >>> ' >>> http://spreadsheets.google.com/tq?key=0AjlSK7_zXoNHdHJ3ZXY2VHAyUWhXcVVkdGUwdXNCeHc&pub=1' >>> ); >>> >>> // Apply query language statement. >>> >>> >>> // 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 view = new google.visualization.DataView(data); >>> view.setColumns([0, { >>> type: 'number', >>> label: 'Value', >>> calc: function (dt, row) { >>> return (dt.getValue(row, 1) > 10) ? dt.getValue(row, 1) : >>> null; >>> } >>> }, { >>> type: 'number', >>> label: 'Value', >>> calc: function (dt, row) { >>> return (dt.getValue(row, 1) < 10 && dt.getValue(row, 1) > >>> 30) ? dt.getValue(row, 1) : null; >>> } >>> }, { >>> type: 'number', >>> label: 'Value', >>> calc: function (dt, row) { >>> return (dt.getValue(row, 1) < 30 && dt.getValue(row, 1) < >>> 50) ? dt.getValue(row, 1) : null; >>> } >>> }]); >>> var data = response.getDataTable(); >>> // set the 3rd column to the "tooltip" role >>> data.setColumnProperty(2, 'role', 'tooltip'); >>> visualization = new >>> google.visualization.ColumnChart(document.getElementById('visualization')); >>> visualization.draw(data, view, {backgroundColor: >>> '#ffffff',legend: 'none', colors:['#336699'],is3D:'True', >>> isStacked:'true'}); >>> >>> >>> } >>> >>> >>> google.setOnLoadCallback(drawVisualization); >>> >>> >>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/nHOWpiuofjYJ. 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.
