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 … Read more

Excel Dashboards: do you need VBA?

Do you need VBA to create an Excel dashboard? Should you take the plunge and go beyond Excel formulas? Well, I think you should, but feel free to disagree. Charley Kyd, commenting on my review of his e-book, disagrees: As a consultant, I visited too many clients where an Excel user had written some macros, … Read more

Excel dashboards according to Charley "ExcelUser" Kyd

If you google for “Excel dashboards”, 6 out of the first 10 results link to Charley Kyd’s ExcelUser website or some of his affiliates. MrExcel calls Charley Kyd “the king of Excel dashboards”. There is a good reason for that. Three years ago, Charley Kyd published an e-book, Dashboard Reporting with Excel, probably one of … Read more

Excel, Crystal Xcelsius, dashboards and domain names

Funny story… I was playing with domain names today, trying to register names for future projects like “exceldashboards.com”. Unfortunately, this is already taken. And who owns it? Business Objects, the makers of Crystal Xcelsius (remember my Xcelsius dashboard series?). Type exceldashboards.com (I refuse to add a link) and you’ll be redirected to the xcelsius home … Read more

10 x 10 Tips to improve your (Excel) charts: general tips

This is the first in a series of 10 posts where I’ll suggest a (hopefully) coherent set of tips to improve our charts and, more important, to improve the way we make sense of the data. These are the planned posts: General charting; Formating; Column/Bar charts; Line charts; Scatterplots (XY charts); Pie charts; Other chart … Read more

The Excel Demographic Dashboard in StarOffice/OpenOffice? Not yet.

I tried to create a Crystal XCelsius version of my Demographic Dashboard and failed miserably. But what about a new spreadsheet version? That should work, right? Wrong. I downloaded StarOffice 8 and just linked the pivot table (“datapilot”) to the Access population database via ODBC and waited… and waited… and waited… and finally was able … Read more