how to do it in Excel

 One common piece of feedback I get after presenting on the topic of data visualization goes something like this: Wow, that was super useful. I’m never going to use pie charts again. But when it comes to the graphs, how do you actually make them look like that? I’m not Excel-savvy…help!

I hate stacked area charts

I keep seeing stacked area charts in my travels around the ’net. Horace Dediu at Asymco, for example, seems particularly fond of them.1 It’s easy to see why. They have big blocks of color to attract the eye, and they don’t look as stodgy as their sibling, the stacked column chart. But I find them often misleading, even when their creator doesn’t intend them to be.

Advertisements