How-to screencasts: Population pyramids in Excel

by Jorge

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.

You may also be interested in:

  1. XCelsius Dashboard: the population pyramid
  2. Creating a VBA-free Excel dashboard
  3. Using Google's Motion Chart to visualize population trends
  4. 10 x 10 tips to improve your (Excel or not) charts: the scatter plot

{ 1 trackback }

PTS Blog » Tornado Charts and Dot Plots
March 3, 2008 at 13:09

{ 2 comments… read them below or add one }

Aleks October 25, 2007 at 21:02

Check out this animated version of a population pyramid for Slovenia at IBMI.

Jon Peltier November 2, 2007 at 19:22

Aleks -

Very nice.

Leave a Comment

Previous post:

Next post: