Easy Bullet Charts in Excel

Easy Bullet Charts in Excel

Here is what a normal bullet chart looks like: There are usually areas of performance in the background (acceptable/unacceptable, in this case), a target line, and an actual bar the represents your real value. Bullet charts kick ass for showing part-to-whole...
Adding Standard Deviation to a Dataviz

Adding Standard Deviation to a Dataviz

Do you need to communicate your standard deviations to your audience? No, I mean, really DO YOU? Think hard about that because chances are your audience doesn’t give a crap. They want to know you calculated your standard deviations. They want to know you were...

Dashboard Icons in Excel

We don’t just report the facts, ma’am. We use a set of values to make judgments about the data, like which of these results is good or needs improvement, etc. We set benchmarks and cut points so our clients can understand when action needs to be taken and...