subscribe
Effective Charts and Dashboards for Excel users

Archive for the ‘Practices’ Category

Why do people make bad charts? [POLL]

Let’s assume that a bad chart is a chart that breaks basic perceptual laws, contains too much fluff, do not respect data relationships and do not clearly answer the underlying question (if you can find one). Why do people make such charts? Below you can find some

Read more

The drummer – a data visualization bedtime story

(…) On the top of the mountain was a plain. There stood an old stone house, and in front of the house lay a great fish-pond, but behind it was a dark forest. He saw neither men nor animals, everything was quiet; only the wind rustled among the trees, and

Read more

How many meters in a mile? Depends on resolution

How many meters in a mile? Depends on resolution

Here is an interesting technique: using two y-axis to display the same data at different resolutions. Yellow (BMI) and blue (Weight) lines should overlap (there is a one-to-one correspondence between BMI and Weight for a given height), but they don’t because they are using a higher resolution

Read more

Excel Charts meet William Playfair

Excel Charts meet William Playfair

Are you sure you can recognize an Excel chart from miles away? I thought that too. Then I started playing with some data visualization historical milestones and now I’m not so sure. Trying to recreate these charts in Excel is a great way to improve your Excel skills

Read more

16 creative pie charts to spice up your next infographic

16 creative pie charts to spice up your next infographic

We know how popular pie charts are in business presentations, but pie charts and infographics is a marriage made in heaven. Let me share with you 16 cool ideas to add pie charts to your next infographic. I’ll add a brief comment to tell you what makes each unique

Read more

Why do people make so many bad charts?

Why do people make so many bad charts?

I refuse to believe that a moderately clever person makes a 3D chart to get better insights from the data. The real reasons behind this behavior have nothing to do with data visualization, and impression management is one of them. Maybe this can be confirmed by research

Read more

Data Visualization Bimbos

Data Visualization Bimbos

Do you know that, according to Amazon, Tufte’s Envisioning Information is a best seller book in Design and Decorative Arts? This man fights all his life against decoration and one of his best books ends up on the Decorative Arts category? Life (or Amazon) does have a twisted

Read more

My Personal Data Visualization Library

My Personal Data Visualization Library

There are many approaches to data visualization. Take well-know authors like Tufte, Cleveland, Ware, Few, Bertin or McCandless. There is some overlap, but they all approach data visualization from a different angle. That’s great news for you: this means that you can come up with a unique

Read more

Change Bad Charts in the Wikipedia

Change Bad Charts in the Wikipedia

Corporate annual reports and the Wikipedia are two great resources to find really bad charts. We can’t do much about corporate reports, but we can actually change the Wikipedia articles. So, here is an assignment for you: find a bad chart and replace it with one that

Read more

Your glossy chart is more than that: it’s how you see the World.

Your glossy chart is more than that: it’s how you see the World.

The French call it l’air du temps, the spirit of the times. You breathe it, you wear it, you eat it. You can’t escape it. Over the last 20 years, the spirit of our times gave us things like: Glossy Pie Chart   McMansion BMW X6 Jeremy

Read more
Page 1 of 512345

Latest Posts

What’s on Your Mind?

Your Name (required)

Your Email (required)

Subject

Your Message

3+2=?