Proven? How? By what standard or metric? And for any business dashboard data vis? What does that even mean?
There are far too many outrageous claims in this article.
There is an example on creating a bullet chart in Excel. It starts with bar chart, which simple and easy to do and read. It then go through many steps to abstract and obscure some the information, to get to a chart that the author find more appealing. I don’t. I think a bar chart as more space and is more zen, while his chart feels crowded. Unless you start with only 3 bars, in which case it looks fine and doesn’t obstruct any information.
> To create a comparison range, you’ll have to pick a colour and make use of four different shades of colour. To help you do this, you’ll have to select the colours one after the other.
> Bear in mind that a bullet graph can either be horizontal or vertical in shape. As clearly mentioned above, the target of the organization must be feasible, and the right tools to reach the target should be provided for employees.
How did that last sentence end up in that paragraph?
Animated it would be useful for an air/fuel gauge project I’m working on for a track car.
Confined display area, Target stoichiometric value (14.7). Current ratio. Historical average.
That said, I can see maybe it would help when you are stacking multiple of these on top of each other and each has its own qualitative ranges.
If you look at a good example it actually is intuitive: https://www.perceptualedge.com/articles/misc/Bullet_Graph_De...
That being said, I don't disagree with you. The point is to know your audience and your goals. Trying to be interesting is great for a lay audience, as are long derivations for a seminar of your peers. Just don't confuse the two.
https://en.wikipedia.org/wiki/Sparkline
But it manages to actually show less information. Sparklines are nice because you keep the time axis so we know if the current metrics is improving or decreasing.
Otherwise just write the number.
KPI #13
2018: 124
2019: 125 (A BIGGER NUMBER THAN 2018, YAY!)Repetitious, poorly-worded, unclear (the "how to" for Excel contains no actual instructions).