Subscribe
Effective Charts and Dashboards for Excel users

Data Visualization Blog

That’s not data visualization

What is wheat and what is chaff? Here is a list to help you take sides: If you want to fit the data into the shape of real-world objects, that’s not data visualization; If you use more than one dimension to represent a data point, that’s not

Read more

The Horizon Graph Is a Reorderable Matrix Too: Unemployment Rate 1976-2012

The Horizon Graph Is a Reorderable Matrix Too: Unemployment Rate 1976-2012

Here is the draft result of my little weekend project, making horizon graphs in Excel: I’m probably using too many color bands, but I like it! The horizon graph is a very compact way to display lots of data points and a shiny example of how to

Read more

Animation, Small Multiples or the Reorderable Matrix? Growth of Walmart, Excel Edition

Animation, Small Multiples or the Reorderable Matrix? Growth of Walmart, Excel Edition

In data visualization, animation is overrated. OK, it’s an interesting option if you can see a clear pattern emerging when displaying data over time/space (and, thanks to animation, we were introduced to this communicator extraordinaire named Hans Rosling). It’s fun to make an animated GIF like the

Read more

The data visualization – data art continuum

The data visualization – data art continuum

Data visualization is becoming a catch-all concept with little analytic usefulness. The infographic plague we have to endure is not helping. It doesn’t have to be that way. Stephen Few wrote recently about the distinction between data visualization (“the goal that data be visualized in a way

Read more

I love 3D bar charts

I love 3D bar charts

OK, maybe “love” is too strong a word. Let’s say that 3D column/bar charts are like a tall and ugly building: better appreciated from the top, where you can’t see it but you can enjoy a great view. Like this: Now, change the viewing angle, remove gaps

Read more

Memo regarding data management and reporting

From: CMO To: All Staff Re: Changes in internal data analysis and reporting Consistent with current efforts to streamline our operations, management team has decided to change the way the company analyses and communicates business data. Recent assessments made clear that we are using just a small fraction of

Read more

Data cannot save us from ourselves

Clay Johnson, author of The Information Diet wrote on Twitter: Redistricting should be done with data & open source software, not by humans. Let me be completely honest: I don’t like golden calves and I can spot two in this single sentence: technology and data. Yes, redistricting should

Read more

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

Data Visualization for Excel Users – How to Make a Chart, Part I: Asking Questions

A new page is available in my tutorial “Data visualization for Excel Users”. It’s the first page of a mini series on how to make a chart and we’ll learn how to ask questions and what type of questions we should ask.

Read more

The best of two worlds: the scatterplot pie

The best of two worlds: the scatterplot pie

The best chart is always task-dependent, but let me assume that you would choose the scatterplot as the best chart and the pie as the worst. They are like water and oil: impossible to mix them! Are they? Let me tell you about a little experiment. I

Read more
Page 2 of 2012345...1020...Last »

Latest Posts

Recent Comments

What’s on Your Mind?

Your Name (required)

Your Email (required)

Subject

Your Message

3+2=?