Tuesday, June 12, 2012

Excel Dashboard Charts

Below you'll find some common or uncommon types of charts that can be put on a dashboard with a brief summary and then a video on how to put it together in Microsoft Excel. The charts covered are:
 

Speedometer (Odometer) Chart

Seems like it wouldn't be a dashboard without some chart that fit the car dashboard analogy. Personally I've found it challenging to implement a speedometer chart or odometer chart. However it seems to be quite popular as a search term. So for those of you that have been looking for a way to create a speedometer chart in Excel, here's a video tutorial for you viewing pleasure.
 
 

Pareto Chart

The Pareto chart is based on the 80/20 rule (or Pareto Principle) that was named after an Italian economist named Vilfredo Pareto. Basically this theory states that about 80% of the effects comes from about 20% of the causes. There's many different statements of the 80/20 rule - 80% of the wealth is held by 20% of the population or 80% of the pollution is cause by 20% of the countries. The video instruction below will show you how to chart your own data to show the Pareto Principle in action.
 
 

Sparklines

Sparklines is a charting concept popularized by Edward Tufte and he defines them as a "small intense, simple, word-sized graphic". Basically they are mini charts that may not have labels, gridlines, or much text. The concept even found it's way into Microsoft Excel 2010 as an added charting feature. However you don't need Excel 2010 to create a sparkline chart. Here's a video on how to create a sparkline chart in Excel 2007.
 
 

Gantt Chart

The Gantt chart is popular in project management and it basically is a bar chart that shows a schedule of events by illustrating start and end dates. Sophisticated Gantt charts can be developed with products such as Microsoft Project, but if you wanted a simple Gantt chart that showed some major tasks Excel works just fine. Here's how you do it:
 

Thermometer Chart

A thermometer chart is useful if you wanted to show how a value is comparing to a target.
 

Bullet Graph

The bullet graph has a similar concept to the thermometer chart but pack much more information. It was conceived by Stephen Few. Not only does it show a target value, but also ranges that could indicate a scale of performance.
 

Scrolling Table

Sometimes your data is best left as a table, but if you have a lot a data and a small amount of space (as in a dashboard) a scrolling table may fit your needs.
 

Line Chart with Target Range

What's a list of charts without a line chart example. Here's one that show a target range.
 

Motion Bubble Chart

Bubble charts let you show data with three data series (x,y,z); the size of the bubbles is determined by the values in the third data series. Making them "move"...that was the neat part!

9 comments:

  1. Hello Friends,

    Very good site you have created. A chart is a graphical representation of your data. Charts can be customized with pictures, graphics, shapes, colours, additional shortcuts, fills and labels. There are different options for viewing your charts, whether on paper or on the screen. Excel courses will cover ways of manipulating graphs. Thanks a lot for creating this type of valuable site...

    Gantt Chart Software

    ReplyDelete
    Replies
    1. Thanks for the comment. One of the most effective ways to communicate data is through graphs or charts. Sometime it is more of an art too because you need to know what to show and what not to show.

      Delete
  2. Hello - How do I create "trails" that trace the path of individual bubbles in Excel, like they do in Google motion charts? Please feel free to email me your response at rdivya09@gmail.com. Thanks!

    ReplyDelete
  3. HI! I really need help with a formula. I saw your youtube video on count uniques/duplicates (https://www.youtube.com/watch?v=PCk6pYQirJg). How do I count uniques/duplicates in a filtered list without the hidden values included? Thanks

    ReplyDelete
  4. How can I deselect all the radio buttons if I want? Please anyone can help? Thanks,

    ReplyDelete
  5. ...It is something like you and those like you are honestly prodigiously amazing and ppl loaded with and committed to realizing life changing great works like these....i am continuously benefiting from my growing skill in analyzing and uncovering powerful information so much needed by my bosses at this critical situation where the organization. has reached due to, majorly,a chronic inefficient leadership and other factors an intrl. NGO IN AFRICA PARTNER TO UNHCR, .....i should say thank you and God Bless You...

    ReplyDelete
  6. NANUM 명품 그래프게임 그래프사이트 부스타빗소셜그래프 추천 가장 완벽하게 그래프사이트를 운영하는 곳을 추천합니다 소셜그래프게임에 대한 안전성을 확실히 해결한 그래프사이트입니다 부스타빗을 조작 없이 즐길 수 있는 메이저사이트로 초대합니다 여기를 클릭하십시오 그래프게임

    ReplyDelete
  7. Microsoft Office Professional Plus 2010 gives you access to your favorite Office applications, email, calendar, HD video conferencing, and the most up-to-date documents. Opt to buy microsoft office

    ReplyDelete
  8. Excel courses will cover ways of manipulating graphs. Thanks a lot for creating this type of valuable site...

    ReplyDelete