Subscribe
Effective Charts and Dashboards for Excel users

Data Visualization Blog

Here's How the Unemployment Rate Sounds Like

Do you want to know how the unemployment rate sounds like? Copy this string: 65536,32768,16384,16384,16384,4096, 4096,2048,1024,1024,256,128,64,16,4,2 and paste it into here (right-click, past). Now the Dow Jones Index: 2,4,4,2,2,32,32,16,64,1024,2048,4096, 16384,65536,32768,16384 All together now: 65538,32772,16388,16386,16386, 4128,4128,2064,1088,1024,2304, 4224,16448,65552,32772,16386 This is fun. (Big gloomy smile.)

Read more

God and Moses? The Differences Between Edward Tufte and Stephen Few

I have a confession to make: my past is paved with chart-making sins, including some capital ones (yes, 3D pie charts, too). But years ago I saw the light in Edward Tufte’s The Visual Display of Quantitative Information and since then I’ve been avoiding eye-candy temptations. Now

Read more

Sub-Prime Charts: Should Data Visualization Be Boring?

In a recent article for the New York Times, Paul Krugman, the 2008 winner of the Nobel Prize in Economics, writes: “The banking industry that emerged from that collapse [the Great Depression] was tightly regulated, far less colorful than it had been before the Depression, and far

Read more

How a Bad Excel Dashboard Made me a More Skilled Excel User

Some years ago, as part of my (then) new job, I had to maintain a monthly updated Excel dashboard. It was a maintenance hell, I hated it, but I couldn’t change it because of my poor Excel skills. “This is stupid, there must be a better way”,

Read more

Irregular Time Series? No. Oversampling.

If you are a market researcher, and you want to make sure that you get more reliable results for a subgroup in a survey, what do you do? You must increase the overall sample size (and spend a lot of money), right? Actually, you don’t. You can

Read more

Focus + Context (a Bar Chart Is Not a Skyscraper)

Textures. 3D. Pie charts. Primary colors. Trends hidden behind labels. Backgrounds. Pie charts again. Clear signs of a bad chart, right? Right. It is so easy to spot a badly designed chart that you can use a computer to do it. Don’t waste your time. Let’s stop

Read more

Will Traditional Charts Survive?

No, traditional charts are useless  in our complex world Over the next 25 years, we will need new visualization tools to replace traditional charts. As you know, line, bar and even pie charts first appeared 200 years ago, with William Playfair, and perhaps until 25 years ago,

Read more

A Secret Message Hidden in an Excel Chart

While playing with some county-level data, I stumbled upon what seem to be a secret message hidden in a bubble chart: Just call me paranoid, but let me ask you this: what is a triangle doing there and why on Earth would the hole in the middle

Read more

Black & White Charts

Now is the winter of our discontent Made glorious summer by this sun of York; And all the clouds that lour’d upon our house In the deep bosom of the ocean buried. By the way, black & white is also a great starting point for better charts.

Read more

Hans Rosling

Hans Rosling was here in Lisbon today, for one of his remarkable presentations. It seems that almost no one in the room new about his TED talks and, of course, everyone loved his charts. He gave his presentation in Portuguese, so some extra points there too… If

Read more
Page 10 of 20« First...89101112...20...Last »

Latest Posts

Recent Comments

What’s on Your Mind?

Your Name (required)

Your Email (required)

Subject

Your Message

3+2=?