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/-/MiywmRNkYdUJ.
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.
