User Tools

Site Tools


charting:gauge-chart
  • Bookmark "Gauge chart" at del.icio.us
  • Bookmark "Gauge chart" at Digg
  • Bookmark "Gauge chart" at Furl
  • Bookmark "Gauge chart" at Reddit
  • Bookmark "Gauge chart" at Ask
  • Bookmark "Gauge chart" at Google
  • Bookmark "Gauge chart" at Netscape
  • Bookmark "Gauge chart" at StumbleUpon
  • Bookmark "Gauge chart" at Technorati
  • Bookmark "Gauge chart" at Live Bookmarks
  • Bookmark "Gauge chart" at Yahoo! Myweb
  • Bookmark "Gauge chart" at Facebook
  • Bookmark "Gauge chart" at Newsvine
  • Bookmark "Gauge chart" at Yahoo! Bookmarks
  • Bookmark "Gauge chart" at Twitter
  • Bookmark "Gauge chart" at myAOL
  • Bookmark "Gauge chart" at Slashdot
  • Bookmark "Gauge chart" at Mister Wong

Gauge chart

A gauge, speedometer or dial chart is a combination of a pie chart and a doughnut chart in the same chart. In this kind of chart views a range of values of a business key. Most times this range is separated in three areas, red colored for low, green colored for high and orange between the other values. What a high value is depends on the context of the business key. An indicator, like an arrow or a needle, point on the present value. At once a users see if the value of the business key is good or bad.

This kind of chart seems to be popular but it has a lot of disadvantages. First a gauge chart is very big. It only shows less data points on a big area. With this space for umpteen charts like line or column charts for example.They show more data in an more efficient way. That the values are related to the angular orientation of the indicator is the second disadvantage of a gauge chart. The best way to view data is when data is plotted as length or positional features like bars, columns or points. In charts with these features an user can notice values more efficient and faster, experts have shown. Another drawback is that a dial chart is hard to build.

An example to build a gauge chart in excel:

  • Select a range
  • Select a doughnut chart Insert tab ⇒ other Charts ⇒ doughnut

  • Select each data point and remove the fill or change the color
  • Remove lines, legend and change angle to 270

  • Select the pie range and change the chart to pie and change the pie angle to 270 as well

  • You can change the needle width and position

  • Bookmark "Gauge chart" at del.icio.us
  • Bookmark "Gauge chart" at Digg
  • Bookmark "Gauge chart" at Furl
  • Bookmark "Gauge chart" at Reddit
  • Bookmark "Gauge chart" at Ask
  • Bookmark "Gauge chart" at Google
  • Bookmark "Gauge chart" at Netscape
  • Bookmark "Gauge chart" at StumbleUpon
  • Bookmark "Gauge chart" at Technorati
  • Bookmark "Gauge chart" at Live Bookmarks
  • Bookmark "Gauge chart" at Yahoo! Myweb
  • Bookmark "Gauge chart" at Facebook
  • Bookmark "Gauge chart" at Newsvine
  • Bookmark "Gauge chart" at Yahoo! Bookmarks
  • Bookmark "Gauge chart" at Twitter
  • Bookmark "Gauge chart" at myAOL
  • Bookmark "Gauge chart" at Slashdot
  • Bookmark "Gauge chart" at Mister Wong
charting/gauge-chart.txt · Last modified: 2016/04/21 19:47 by Wiland Beck