This chart does not use the formatted values, but we are about to add support for number formats in the next few days. Hope this will help you get to what you want to achieve.
Regards, VizGuy On Sat, Apr 4, 2009 at 7:30 PM, Mayank Gupta <[email protected]>wrote: > > 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<http://spreadsheets.google.com/pub?key=pN-lkCy-%0AUu45szAJ_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 -~----------~----~----~----~------~----~------~--~---
