Horizon charts in Excel [bonus file]

A single horizon chart is easy to make in Excel using overlapping columns or areas (the trick is to structure the data the right way). But the horizon chart is a variation of small multiples, so what makes sense is to stack them to compare multiple entities. That’s problematic in Excel. But many charts can … Read more

12 ideas to become a competent data visualization thinker

It began with a tweet: Data tweeps: Help! I need to become a competent data viz thinker, well, immediately. Are there “must-read” sources that y’all can suggest? — Lindsey Leininger (@lindsleininger) September 27, 2017 In spite of being a notorious Excel Brute Forcer (thanks, Elijah!), I was invited for a presentation at JMP and was working on … Read more

On alternative pizzas, pie charts and datavis pedantry

pizza mistaken for a pie chart

So our usually calm data visualization corner on Twitter was shaken by this tweet: Forget pepperoni – mushroom is Britain's most liked pizza topping (65%), followed by onion (62%) and then ham (61%) https://t.co/5kYikXOEtF pic.twitter.com/AJezMfJHbk — YouGov (@YouGov) March 6, 2017 quickly followed by this one: We're very sorry for the confusion, but this is … Read more

Etiquette for scientists

You are a brilliant scientist and you just made an amazing discovery. You want to announce it to the world. So you prepare a few slides and decide to use that cute font, Comic Sans. After the presentation you realize that, although people praise you for your discovery, a very vocal minority mocks you for … Read more

The cave

Michiel Coxcie: De grot van Plato

Stephen Few and Alberto Cairo (Alberto is the host, that’s why he doesn’t say much) And now let me show in a figure how far our nature is enlightened or unenlightened: –Behold! human beings living in a meeting room, which has a projector with a Powerpoint presentation always turned on; here they have been from … Read more

Two datavis places I don’t belong to

I’m an introvert, so it’s very easy for me to also be an uncompromising Marxist (the Groucho flavor), specially when it comes to club membership (I don’t care to belong to any club that will have me as a member) but things changed since I discovered data visualization. I love it and love this loose … Read more