Why You Don’t Need A Gauge Chart Add-On

There are many dashboards which feature gauge charts as important components of their displays. This leads a lot of novice dashboard designers to think that these are vital, useful and necessary charts which should always be incorporated into a dashboard design. While initially it may seem that these charts do give a lot of necessary information, on closer inspection it can be seen that they are in fact quite limited and that a simple line chart can provide considerably more data while occupying the same space.

A gauge chart is capable of providing at most four items of information. Firstly, its needle tells you a particular value. This is typically the current value of some key data set. The colours on the gauge then provide you with three other pieces of information – which values are defined as the danger areas, which are considered to be average, and what value most be exceeded to achieve optimum performance. While these are all valid and important data points, they can easily be displayed using the background colours of a line chart and a single data point.

You can view a gauge chart as a vertical cross section of the very last point of a line chart, where the background has been coloured red, orange and green. The red area is of course the negative region of the chart, the orange is average and the green is good. Clearly, the finally data point of the line chart gives you an indicator of where this particular KPI lies, and also it’s precise value. Crucially however, the remainder of the line chart provides you with additional information that can dramatically affect the interpretation of this data point. If the trend line has dropped suddenly towards this final value this gives a certain impression, as opposed to a trend line that has fluctuated in or around that same final value over a given period of time. Clearly, this data is important for correct analysis of KPIs and to help determine strategies going forward. There are many add-ons available for download which allow you to generate gauge charts in Excel. However it is quite obvious that these charts are largely ineffective and inefficient.

Nov
11

3 Responses to “Why You Don’t Need A Gauge Chart Add-On”

  1. 鞎勲敂雼れ姢 旃错攧毽?韺笭 says:

    鞎勲敂雼れ姢 旃错攧毽?韺笭…

    22▲로리 매킬로이(사진=PGA)스페인 차세대 기대주 존 람(23)이 조던 스피스(미국)를 3위로 끌어 내리고 세계골프랭킹 2위에 올랐다….

  2. 臧€欤?頂岆灚 鞀堨 says:

    臧€欤?頂岆灚 鞀堨…

    이승훈은 “쇼트트랙 코스에서 훈련해야 해서 그렇게 했다”면서도 “그런 훈련이 다른 동료에게 상처 줄 것으로 생각하지 않았다”고 밝혔다….

  3. 鞎勲敂雼れ姢 鞏戫劯 頉勲摐 歆戩梾 says:

    鞎勲敂雼れ姢 鞏戫劯 頉勲摐 歆戩梾…

    박성현, 루키 고진영(23ㆍ하이트진로), 전인지(24ㆍ), 김효주(23ㆍ롯데), 김세영(25ㆍ미래에셋) 등은 출전하지 않았다….

Leave a Reply

You must be logged in to post a comment.