Subscribe
Effective Charts and Dashboards for Excel users

Archive for the ‘Theory’ Category

Charting tips 002: Consider the task at hand

Suppose you are sharing a list of orders with some co-workers. One of them wants to see the higher sales orders [list]. Another one wants to know how much was exported to France [table]. The next one needs the average items per order [descriptive statistics]. You want

Read more

Charting tips 001: Do you really need a chart?

A chart is just one of the available tools to communicate and help you and your audience to understand the data; sometimes using a chart is just plain wrong: if variation seems random or non-existent, what’s the point of displaying the data graphically (yes, I know, sometimes

Read more

Sparklines, Excel, Crystal Xcelsius and stealth-mode charts

You struggle every single day to design the best, the most eye-catching chart for the next presentation. If your goal is to impress your boss, you can stop reading, I have nothing new to offer, I can’t even impress mine. But if you really want to understand

Read more

The "what-would-Tufte-say" syndrome

An alarming level of the “what-would-Tufte-say” syndrome can be found in this post and some of its comments discussing a New York Times’s infographic. This syndrome has some recognizable features like the extensive use of “chart junk”, “lie factor” or other terms and expressions coined by Tufte

Read more

Visualizing change with Stephen Few

Well, I must say I am a bit disappointed with the September issue of Stephen Few’s Visual Business Intelligence Newsletter. It discusses an important but much neglected topic, visualizing change through animation. Few’s paper was written for SAS Institute, and uses JMP, a statistical analysis product from

Read more

Animation and demographic information visualization

[Update: I posted a tutorial screencast that shows different population pyramids that can be created using Excel.] Let me assure you that this is not a post on how to make your pies fly in PowerPoint. I am talking about the kind of animation that you can

Read more
Page 6 of 6« First...23456

Latest Posts

What’s on Your Mind?

Your Name (required)

Your Email (required)

Subject

Your Message

3+2=?