Archive for admin

Author Image

The consultant’s chart: a dilemma

How do you sell your outrageously expensive consulting services? Simple, just add a chart…
Not every chart will do, of course. Let me outline some basic design rules of what I call a “consulting chart”:

It shouldn’t be recognizable as a standard chart that you could create in Excel;
It shouldn’t use popular eye-catching design elements, like 3D […]

Announcement: writing for a new blog

I’m very pleased to announce that I’ll be writing for Bonavista Systems‘ new company blog, More Information per Pixel.
As you may know, Bonavista is the maker of MicroCharts, the best implementation of Edward Tufte’s sparklines for Excel. Their parent company, XLCubed, offers analysis, reporting and dashboard solutions that extends the power of Excel much beyond […]

Uncommon knowledge about pie charts

I’d like to answer or comment on search queries that bring readers to my blog. Here are some of them involving pie charts:
What is the usefulness of pie chart in research?
Research found that many pie charts resemble Pac-man.
Pie charts of the american revolution
They go very well with the Powerpoint version of the Gettysburg address.
How to […]

Performance vs flexibility in Excel: Demographic Dashboard Lookup Edition

I am sure Albert Einstein was thinking of Excel dashboards when he said “everything should be made as simple as possible, but not simpler”. Let me tell you why.
Demographic Dashboard: The VBA edition
I published some time ago a first version of my Demographic Dashboard to show how an average Excel user could design a […]

Car dashboards: a broken metaphor for executive dashboards

Some metaphors are really stupid. Convincing people that running a company is like driving a car and you need a similar dashboard is one of them. If you are naive enough to buy it, most dashboard vendors will happily fill up your precious screen real estate with irrelevant gauges and and speedometers designed to look […]

Excel chart gallery: a difficult equilibrium


Video: Hans Rosling: Watch the end of poverty


Video: Hans Rosling: Debunking third-world myths

I’ll be adding some classic videos here, and Hans Rosling must of course be one of the first to be included. He is using visualization software that later was bought by Google. I am using it to display old vs young dependencies.

Excel dashboard competition

Bonavista Systems announced today an Excel Dashboard Competition. Participants stand a chance to win an iPhone, a workshop hosted by Stephen Few and a copy of Few’s “Information Dashboard Design”. Unlike other competitions, there is no data set. You just have to use Excel and MicroCharts, their sparkline generator. You don’t need to buy MicroCharts […]

Using Google’s Motion Chart to visualize population trends

Using Google’s Motion Chart to visualize population trends

In my Demographic Dashboard I have a scatter plot that shows the trend towards an aging society. Today I wanted to test the new Google Chart API and the Motion Chart with the same data set.
The chart displays the old dependency ratio against young dependency ratio. It clearly shows the shift from high ratios of […]