Available Chart Types in Google Spreadsheets
Dashboard Spy readers have been asking me to elaborate on the use of Google Spreadsheets as the charting engine for dashboard KPI graphics. As you may know, Google Docs is a free product that offers web-based office suite functionality including word processing, presentations and spreadsheets. While it is often accused of being “10 years behind Microsoft Excel”, the Google Docs Spreadsheet does offer some excellent features for us dashboarders. I’ve been investigating the use of the product’s ability to publish data charts over the web.
Here’s a quick look at the charts:

There are five types of charts that are available:
Columns - with 4 sub-types
Bar Charts - with 4 sub-types
Line Charts - with 5 sub-types
Scatter - with 3 sub-types
As demonstrated in this ”Ask the Dashboard Spy” video on coding dashboard portlets in html, we can take great advantage of the fact that Google Docs allows the creation of spreadsheet graphs that can be accessed over the web via their own URLs.
By the way, here is the url for the entire collection of Dashboard Spy videos.
Continue reading to see 2 helpful Google Docs videos:
If you would like to see a bit more of the Google Spreadsheet charting capabilities, here is another introductory video.
And this video is from a famous series of videos called In Plain English. It explains Google Docs.
Tags: Google Spreadsheet Graphs for dashboard charting, Google Docs for Dashboarding
Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.
What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.
Leave a Reply
Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:
- Google Sites Dashboards - Project Management Dashboard Example ...
- 7 Common Dashboard Chart Types ...
- Dashboard Spy Video Tutorial on Coding HTML for Portlets ...
- Project Management Dashboard shows Level of Effort (LOE) Metric ...
- Mashup Dashboards with Websphere Portal and Google Gadgets ...
- Making Dashboards More Productive - Google Analytics Dashboard Case Study ...
- Heat maps - an eye tracking data visualization technique ...
- How Microsoft Designed Excel 2007 Graphs and Charts ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Xcelsius 2008 Dashboard - Gas Price Data
- Small Business Dashboards
- The Horizon Graph
- Who is on your list of Dashboard Experts?
- Flex Dashboard at the Federal Reserve Bank of Boston
- 4 Principles for Dashboard Gauges
- Flash Dashboard Example - Information Visualization about Oil Production
- Making Dashboards More Productive - Google Analytics Dashboard Case Study
- Dashboard Eye Candy
- So Where are the Excel 2007 Dashboards?


