Are you focusing on F word or S word? [Charting Principles]
When you are making a chart next time, spend just 5 minutes (or even less) on the formatting and give more time (may be 20 minutes) to think about the story.
Often we spend a lot of time fine tuning our chart formatting that we neglect the story. We fail to understand what the bars and lines mean. Most of the charts (even the real ugly ones) can be cleaned up and made presentable in a few minutes. Unless you are giving a keynote presentation about the next iPhone, I don’t think spending more time fine tuning formats is necessary. But even the simplest charts can often take hours of story-telling.
Thanks to newer and better versions of charting software, making pretty charts is an easy job. But telling compelling stories, alas, no software can match you.
Don’t confuse formatting with overall chart making process. You still need to spend sometime figuring out the right chart. That is why Jon and I have started the new chart doctor, where we take badly made charts and convert them to better charts so that it is easy to tell the story.
More naughty but very important charting lessons:
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Gantt Charts – Project Management Using Excel [Part 1 of 6]||Creating New Cell, for real »|