Hi Megan, If you already have an interactive Excel sheet, you could try replicating the same functionality in Google Spreadsheets using Google Apps Script ( http://www.google.com/support/forum/p/apps-script/ ) which allows you to define 'macros' and custom functionality on top of your Google Spreadsheets data (just like Excel macros do). Google Apps Scripts requires you to use the Javascript language to define the interactive functionalities you need. They have various tutorials here : http://code.google.com/googleapps/appsscript/articles.html
You could arrange your tool in this way: - define a Google Spreadsheet containing your data a few interactive controls that, once clicked, trigger a Google Apps Script function to do the computations you need and write the generated output (the three columns of data) in some other part of the spreadsheet (maybe a separate sheet?) - have a line chart, embedded in the Google Spreadsheet, use such generated output as its input. It should then update automatically whenever the data changes. This would let you achieve what you need while remaining within Google Spreadsheets, and hopefully without having to write too much code aside from the actual calculations your macros already contain. -- R. On 9 September 2011 19:15, asgallant <[email protected]> wrote: > Welcome Megan, > > I suspect that this is doable, but perhaps not in the way you're thinking. > I have no experience with Google Spreadsheets, but I don't think there is > any way to modify data or trigger macros attached to the sheets via the > Visualization query API. What you could try, though, is setting up the > calculations server-side in PHP or client-side in javascript, though if > you're new to coding, then javascript is probably easier to work with. I > took a quick look at the wiki entry you posted, and I *think* it requires > some functions not explicitly provided by javascript, but it doesn't look > like there's anything you *can't* do in js (with some custom functions) > either. > > Mozilla has very good javascript reference documentation: > https://developer.mozilla.org/en/JavaScript/Reference, in particular you > may have need of the Math object: > https://developer.mozilla.org/en/JavaScript/Reference/Global_Objects/Math > > http://www.jsfiddle.net/ is a good place to play around with javascript to > test things out (and you can save your code to share with others if you find > something vexing or have a brilliant idea). > > Google's Visualization Playground ( > http://code.google.com/apis/ajax/playground/?type=visualization) lets you > experiment with the various kinds of charts, examine the different ways they > can be constructed, and see what the options do. > > Googling "javascript tutorial" will get you a bunch of resources, though I > would recommend against anything from W3Schools - they are often vague, > incomplete, or just plain wrong about the subjects they purport to be > experts in. > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/google-visualization-api/-/qhUBk08GcUEJ. > > 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. > -- 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.
