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
-~----------~----~----~----~------~----~------~--~---

Reply via email to