Scan down a column – it’s easy to see numbers over time. Notice that numbers are increasingly greyed down – recent ones in black (they’re most important, so are prominent), recent ones in dark grey, old ones in light grey (least important). This greying-down is a neat trick for big tables – a big table is intimidating for readers when they first see it… so many numbers, where do I start? Greying down selected bits makes the table look less daunting, plus creates visual hierarchies and distinctions.
Notice also the top right label: ‘Gun (new line) Confisc- (new line) ations’. It isn’t the normal word-wrapping we’d get in an Excel cell. Rather, I typed: “Gun” (Alt Enter), “Confisc-“ (Alt Enter), “ations” (Enter). I get the word-wrap I want, not the word-wrap that the column width gives me. Neat.
Changing word-wraps…? Is that a bit OCD? Obsessive? Perhaps, but remember: it’s not easy to do good dashboards – the devil really is in the detail. Then again, if good dashboards were easy to do, we’d all be doing them. But we don’t. Most people do bad dashboards. Great dashboards are as rare as hens’ teeth. So if yours is great, you’ll shine. It’ll impress bosses for many months after. It’s the gift that keeps giving.
So, this email update has shown when to put in columns, not rows. And how to get the word-wrap we want. Together, they further improve our dashboard a bit. But we're still not there yet. To be continued the next month.
Time for the fun stuff. Do please read the 'Fifty Ways' section that's further below - it kickstarts a theme that continues through this email-series. Also, at the end of the series, I use the theme to help prevent bad graphs, plus there's a punchline that's truly absurd. Stay tuned.
|