Subscribe
Effective Charts and Dashboards for Excel users

Data Visualization Blog

Excel Game Changers

You can learn a lot from an expert, but a game changer challenges your believes and assumptions and, at some point, that’s exactly what you need to move forward. Creative destruction. I love it. Let me tell you about three of my personal Excel game changers. Jon

Read more

Alphabetical Sorting Must Die

If you follow Jakob Nielsen’s Alertbox, you know I’m shamelessly stealing this post title from him. He says that most of the time a list is sorted alphabetically because a) it’s easier to find a name and b) designers are lazy and don’t want to bother finding

Read more

Data Visualization, Ikea style

Data Visualization, Ikea style

Seven years ago, my wife and I drove 400 miles to the nearest Ikea store and bought furniture for the entire house. Today we have two stores in our city. Things change. Last week we bought a large, wall-to-wall bookcase and replaced some of the old stuff.

Read more

The Consultant’s Chart Revisited

A year ago I wrote a post about the circumplex chart and how consulting firms use charts to increase their price tag. Not all charts, mind: only the ones that the average user don’t recognize from the Excel charts library. Funny enough, I got several messages from

Read more

Memorable Charts? Forget About It!

This too much discussed paper “found that people’s accuracy in describing the embellished charts was no worse than for plain charts, and that their recall after a two-to-three week gap was significantly better. In addition, participants preferred the embellished charts“. OK, let’s take a deep breath. Apparently,

Read more

The Healing Power of Statistics

A week ago, my father underwent a risky surgery. The doctors weren’t sure if they should do it, given his old age, but we all agreed that letting the disease take its course was not an option. After a week, he seems to be recovering well. He

Read more

How Do You Sell an Excel Dashboard?

Dmitry asks: I face an issue that has nothing to do with Excel itself: human resistance. I showed a dashboard to my manager and he answered to me that my dashboard is too difficult for him and for top management and insisted to use simple XL-tables with

Read more

On the Brink of the Abyss You Don’t Want to Be Pushed

There are so many bad charts published every single day that redesigning some of them would be a full time job. Many are involuntarily funny. And there are some dangerous and stupid ones. I live in Portugal, a small country that only gets international press coverage when

Read more

No, Tufte’s Charts Are not Plain and Simple

A new data visualization research paper finds that chart junk does not harm accuracy and actually improves recall. The paper is an interesting read but, unfortunately, not for the right reasons. I’ll discuss the paper in an upcoming post. Today I just want to comment a sentence

Read more

Want to Improve Your Excel Skills? Learn Access

What if you love Excel for all the wrong reasons? What if its flexibility creates nothing more than a glorified mess? What if you start neglecting the skills that truly matter? Every formula in Excel is an accident waiting to happen. Sometimes, a parameter is missing, sometimes

Read more
Page 6 of 20« First...45678...20...Last »

Latest Posts

Recent Comments

What’s on Your Mind?

Your Name (required)

Your Email (required)

Subject

Your Message

3+2=?