I would like to format the 4th column using 5th column so that in
annotated time line 5th column value can be displayed
But I think it is not working for annotated time line
Please help me.
You can see spread sheet for my data at
http://spreadsheets.google.com/pub?key=pN-lkCy-Uu45szAJ_NFhyAw
google.load('visualization', '1', {packages: ['annotatedtimeline']});
function drawVisualization() {
new google.visualization.Query(
'http://spreadsheets.google.com/pub?key=pN-lkCy-
Uu45szAJ_NFhyAw').send(
function(response) {
var aDataTable = response.getDataTable();
var formatter1 = new
google.visualization.PatternFormat("'{5}");
formatter1.format(aDataTable,[0,1,2,3,4,5],4);
var aDataView = new
google.visualization.DataView(aDataTable);
aDataView.hideColumns([1,3,5,6]);
var chart = new google.visualization.AnnotatedTimeLine
(document.getElementById('rightcontent'));
chart.draw(aDataView, {width: 680, height: 400, is3D:
true,displayZoomButtons: false,scaleColumns:
[0,1],scaleType:'allmaximize',colors:['red','black'],
'displayAnnotationsFilter':true,fill:50});
});
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---