As most people who know me will attest, I am a big fan of using gauge and bullet charts and / or altering the standard excel charts to make them more visually appealing. So when I was asked by a colleague if I could create a gauge style graph, with an arrow as an indicator of the result (kind of like a linear speedometer), my exact words were, challenge accepted.
To make sure I fully understood what they wanted, I asked them to send me a picture. This is what I received:
After further discussions, we realised that she wanted a percentage scale going from 1 – 100%. The blue arrow would move based on the indicator for that month. There are actually several ways that this chart could be made. I chose in this instance to make a bar chart. It could also be done with a column…
View original post 630 more words