Oops, I left out the tooltip column in the link I posted. Is this what you're looking for: http://jsfiddle.net/asgallant/JENzE/3/?
On Wednesday, January 9, 2013 4:17:21 PM UTC-5, Justawebbie wrote: > > 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/-/HOrYjBa6T3IJ. 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.
