Dashboards

    Dashboards By Example Volume 1   From Excel Dashboards to Real-Time Dashboards, these dashboards contain KPIs, metrics, charts, trends and data visualizations. Learn the best practices of enterprise dashboard design by studying the work of your peers on business dashboard implementation teams around the world. Examine their digital dashboards and share your dashboard design tips in return.

For more Business Intelligence Dashboard Examples, use this link to the Dashboard Spy sitemap: Dashboard

Note: Dashboards By Example readers can get these interesting business intelligence dashboard white papers discussing the latest approaches to enterprise dashboards.

Want to connect with the Dashboard Spy? Visit the About The Dashboard Spy page to learn how to connect via LinkedIn.
« Dashboard Spy Video Tutorial on Coding HTML for Portlets
Dashboards from an IT Operations Portal »

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:

Google Spreadsheet Chart Types Google Docs 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

Learn how to create Excel dashboards.Excel Dashboard

What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.  

One Response to “Available Chart Types in Google Spreadsheets”

  1. Anonymous Said on March 26th, 2009 at 5:09 am quote

    ermm
    not very pleaseing!

Leave a Reply




Last Modified: Friday, October 26th, 2007 @ 11:47

This business intelligence dashboard blog entry was posted on Thursday, October 25th, 2007 at 2:48 pm and is filed under Dashboard Screenshots. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Want to see a different randomly selected business intelligence dashboard example? Click here to view another Digital Dashboard from the Dashboard Spy.

Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:

Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?