Monday, December 10, 2012

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 spreadsheet
  1a. 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 Configuration
Non-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