Hi, It's too troublesome if I have to always change the charts parameters (data range). I would like that there were only one chart and if I change the drop-down component value new look will be displayed on the chart. I don't want to use multiple charts too because there are quite many different characteristics to display and using only one chart helps keeping spreadsheet compact and easily to use.
Aivar On 8 jaan, 23:04, MC Get Vizzy <[email protected]> wrote: > If you have two sheets in the same document, you can display charts without > writing code by going to Insert/Chart on the menu. > > Hope that helps, > > MC Get Vizzy > > > > On Sun, Jan 8, 2012 at 10:19 AM, Aivar Jõgi <[email protected]> wrote: > > Hi, > > > I have two spreadsheets in Google docs. The first one containts data > > and the second is intended for visualisation of first spreadsheets > > data. My plan is to put drop-down element and graph on the > > visualisation spreadsheet and when a choice is made in drop-down, > > different data ranges from first spreadsheet are feeded to the graph. > > I thougt that I can solve this problem by writing some scripts for the > > spreadsheets using Google Visualization API. I found some examples > > (http://code.google.com/apis/ajax/playground/? > > type=visualization#annotated_time_line) but I I'm not sure if I can > > use them in my spreadsheet (script editor does'nt recognize Google > > Visualization API). > > So, my question is that can I use Google Visualization API for writing > > scripts for google spreadsheets? And if not, is there any solution for > > my problem described above? > > > Thanks for advance, > > Aivar > > > -- > > 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.- Peida > >kommenteeritud tekst - > > - Näita kommenteeritud teksti - -- 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.
