You're welcome. On Thursday, January 10, 2013 12:40:02 PM UTC-5, Justawebbie wrote: > > Oh yes thank you so much Asgallant! Have a great week! > > Take care, justawebbie > > On Wednesday, January 9, 2013 1:01:22 PM UTC-9, asgallant wrote: >> >> 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/-/FLRXjmxjEqQJ. 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.
