Modules
Google Spreadsheet - XY Plot and Drill Down
- Creator:
- byron
- Submitted:
- Apr 28 2007 at 3:30 pm
- Last Updated:
- Apr 28 2007 at 3:30 pm
Download Module
Begin your download of this module (402.4 KB total download).
Description
Use this to view and drill down into data from one of your Google spreadsheets. The regression needs two numeric attributes, but you can always go in and delete it if you want.
The XY scatter plot is interactive, and there is are a number of user configurable options for you to play with:
1. You can dynamically select what to show on the X and Y axis
2. You can "group" the data by a third category attribute. To turn this off, go to the graphs property panel and un-check the Series by 3rd Attribute option.
3. You can filter the data with a simple inclusion / exclusion filter I pulled from the gallery.
This makes it easy to only plot certain values.
4. You can see a single selected point on the screen, or pop up a view of all the selected points. Configure this view as you like.