Evaluation: Google Drive Spreadsheet Charts
Just playing around with the charts to see what I can use it for. Spent a couple hours over a span of a few days as of 12/10/2012.
Features
1. Create chart inside spreadsheet1a. A sheet specifically for the chart for larger view
2. Chart types
2a. 8 types of charts: Line, Area, Column, Bar, Scatter, Pie, Map, Trend
2b. Special charts: Gauge, Organization Chart, Tree Map, Table
3. Easy to update cosmetics
3a. You can basically click on any items on the chart to edit the values, fonts, etc.
3b. The configurations are not very consistent
4. Graph multiple data in a single chart
4a. Cannot set different ranges for each column of data
5. Features I haven't tested
5a. Copy chart, publish chart, Save Image
Additional Details
Inconsistent ConfigurationNon-issue
I can only edit the vertical axis via the graph interface. There is no field in the advanced edit form. This was just confusing when I started because I was going through all the advanced edits and didn't realize I could click on the chart.
Multiple range for multiple data
Nice to have feature
The reason I would like this is because I had two sets of data that have smaller fluctuations relative to the difference between the data points of the two columns. For example, I have weight around 160 +/- 5 pounds and waist around 35 +/- 0.5. The lines look practically flat when the graph range is between 0 - 200. It would be nice if I could set the weight range to 155 - 165 and waist to 34 - 36 so that I can better evaluate the correlation between the two.
No comments:
Post a Comment