Jorge Camoes’ Charts

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 [...]

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.

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 [...]

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 [...]

Do you need VBA to create an Excel dashboard? Our recent discussion clearly shows two lines of thought: a) you should use it because there are things you just can’t do without VBA and if you have access to a powerful tool you should put it to work; b) you should avoid VBA like the [...]

I just added a poll to the sidebar on the right (RSS readers might need to visit the site to see it). I’d like to know if you use recorded macros or write VBA in Excel.
I ran an informal poll among friends and colleagues with catastrophic results and I’d like to compare results.
Please add a [...]

Always ask yourself: “what can I remove from this chart”? Remove Excel defaults, remove grid lines, make the chart smaller, use soft colors, remove irrelevant labels, remove the legend (by directly labeling series), remove series that you don’t really need, remove frames, remove decimal places, remove visual fluff.
Then ask yourself: “what can I add to [...]

I am sure that, if you aren’t a visitor from another planet, you already saw this video. I’m playing with the blog’s template during this week, trying to add interesting stuff from the information visualization point of view, like videos and images, and this is a good test video. This will not change my focus [...]