How-to screencasts: Population pyramids in Excel
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 also guess from my previous posts that I don’t like the Excel default charts (but who does?); and I prefer less traditional population pyramids.
If you google for something like “population pyramids how-to Excel” you’ll get several links that usually tell you how-to, but the end result is rather basic (some of them don’t even show the final result!). I thought I could show how a population pyramid is done in Excel but at the same time discuss pros and cons of alternative designs.
If you're new here, you may want to subscribe to my RSS feed or subscribe via e-mail. Thanks for visiting!
Loading ...
[…] [Update: I posted a tutorial screencast that shows different population pyramids that can be created using Excel.] […]
[…] discussing how to create population pyramids, I wrote that I don’t really like tornado charts, specially if you only have two series, […]
Check out this animated version of a population pyramid for Slovenia at IBMI.
Aleks -
Very nice.
[…] side-by-side rather than one atop the other. Jorge Camoes has written about population pyramids in How-to screencasts: Population pyramids in Excel and Animation and demographic information visualization. Jorge also thinks these charts are not as […]
[…] Use a scatter plot as an alternative to horizontal bar charts, like in a population pyramid; […]
[…] already published a screencast on how to create a population pyramid, but this technique is missing. I wanted to recreate a popular chart format in magazines: lines to […]