Can my Excel Demographic Dashboard be recreated in Crystal XCelsius? This is the main theme for this series of posts. In the first post I set the stage, define the rules and show how the basic “demographic KPI’s” can be displayed using gauges. The second post discusses one of the major drawbacks I find in [...]
Read Morepopulation pyramid
Screencast: How to create a population pyramid in Excel. I am a big fan of screencasts, as a regular reader of this blog may have already noticed. They are great at showing how to use a tool to get something done and they are the best companions for tutorial (e-)books. This hypotetical regular reader might [...]
Read More[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 see in the famous Hans Rosling’s presentation in [...]
Read More


Hi. My name is Jorge Camoes and I'll be your host around here.