Rhizosphere v0.7 has just been released and includes important improvements in the area of Google Spreadsheets and Google Visualization integration.
Since the earliest releases of Rhizosphere, you have always been able to visualize data from your Google Spreadsheets or any custom Google Visualization API datasource. However, up until today, you only had access to a subset of Rhizosphere features when loading data from those sources. The main issue was related to the fact that both Spreadsheets and Google Visualization API model the datasets they handle as a bi-dimensional tabular data. This limits the type of relationships you can define: there is no explicit way in Google Spreadsheets to specify that a given row (for example representing an employee record) is linked to any other row (for example representing the employee manager). As a consequence, Rhizosphere was not able to offer advanced visualizations (like trees and treemaps) when visualizing data loaded directly from Google Spreadsheets.
Rhizosphere v0.7 introduces several conventions you can use to represent hierarchical data in Google Spreadsheets (and any other Google Visualization API datasource). You have now access to Rhizosphere tree and nested treemap representations of your Google Spreadsheets data. This builds on top of existing Rhizosphere features, which means you can slice'n'dice Spreadsheet-based treemaps using Rhizosphere dynamic filters and navigate them back and forward using Rhizosphere HTML5 History support.
Rhizosphere feature set surpasses equivalent visualizations that have been available so far (Google Visualization orchart, Google Visualization treemap):
Get started by having a look at the documentation for Google Spreadsheet users and Google Visualization API users.
If you want Rhizosphere to infer a hierarchical structure from your Google Spreadsheet data, use any of the following conventions.
Make sure the label of the column containing the parent data follows this naming rule:
Rhizosphere will automatically pick up the relationship between the two columns and will let you display the data using either trees or treemaps.
Again, Rhizosphere will automatically rebuild the tree structure for you.
The two included Rhizosphere visualizations display the organizational chart and a treemap of sales data arranged by department. You can find the original spreadsheet here.