Hi Saif, Image Charts uses server side rendering which is a fast rendering engine for charts. The API includes static data as part of the URL and cannot reference external data sources. The interactive charts do not include two Y axis at the moment so they cannot be used as you wanted.
I cannot think of a dynamic solution with two axis at this point in time. --Ed On Wed, Aug 4, 2010 at 2:42 PM, shaq <[email protected]> wrote: > Hello, > Currently ,for charting in google spreadsheets i am able to > plot only single value scale on Y axis. I am unable to plot on both > the Y axes(left and right) each having a different scale...say one can > range from 1/10th to 1/100th and the other from 100 to 10000...The > idea was to plot values which range widely and are not well > represented on a single Y axis.. > Since google doesnt yet support such feature,I understand the > alternate feature is with a gadget in spreadsheet using Google > Visualization API.I used the Chart wizard to generate the type of > chart i wanted from here: > http://code.google.com/apis/chart/docs/chart_wizard.html > > Then clicking on "EMBED WITH VISUALIZATION API" gives the html > code,now this appears like it takes static data.How do i modify it so > that cell contents from a spreadsheet are taken.I think its "&chls" > option but assigning it to a variable looping through the spreadsheet > cells didn't work. > > Can anyone help me out in this.Am i on the right track or is > it possible to add this feature like this?? > > Regards, > Saif > > -- > You received this message because you are subscribed to the Google Groups > "Google Chart API" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-chart-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-chart-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Chart 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-chart-api?hl=en.
