Quick Update, the SelectionHandler is now working (example here:
http://www.heavencore.co.uk/test.htm)
My next task is to replace the column and row indexes in the following
message with the actual column names and row title (value in the first
column?)
Replace: "You selected {row:2,column:6} = 13"
With: "You selected {row:'2009/20',column:'Broadband'} = 13
Any tips on how to modify the following to return the required values?
'############CODE
google.visualization.events.addListener(chart, 'select', function() {
var selection = chart.getSelection();
var message = '';
for (var i = 0; i < selection.length; i++) {
var item = selection[i];
if (item.row != null && item.column != null) {
var str = data.getFormattedValue(item.row, item.column);
message += '{row:' + item.row + ',column:' + item.column + '} =
' + str + '\n';
} else if (item.row != null) {
var str = data.getFormattedValue(item.row, 0);
message += '{row:' + item.row + ', (no column, showing first)} =
' + str + '\n';
} else if (item.column != null) {
var str = data.getFormattedValue(0, item.column);
message += '{(no row, showing first), column:' + item.column +
'} = ' + str + '\n';
}
}
if (message == '') {
message = 'nothing';
}
alert('You selected ' + message);
});
'############END
On May 29, 5:30 pm, HeavenCore <[email protected]> wrote:
> Hello there, i have a Stacked Column Chart with quite a lot of data:
>
> http://www.heavencore.co.uk/viewpage.php?page_id=21
> (give it a few seconds to load)
>
> I need to basically add an event on column click that will return
> values of the column (eg 2009/22), series (eg: Broadband) and value
> (eg: 3) (basically exactly what the native tooltiup does)
>
> I have managed to add a listener to alert() the '2009/22' using:
>
> google.visualization.events.addListener(chart, 'select', function() {
> var row = chart.getSelection()[0].row;
> alert('You selected ' + data.getValue(row, 0));
>
> });
>
> However, this is not what i want, i understnad i have to deal with
> rows and columns here, but i am struggling to get the syntax right.
>
> Please help!
>
> Many Thanks!
>
> Jordon
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
