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.
Check out this animated version of a population pyramid for Slovenia at IBMI.
Aleks –
Very nice.
Hi
I have date from worldwide, can you recomment a map?
Thank in advance
Marco
Search for “world map Mercator projection” in the Wikimedia Commons. You should get a usable map there.
yes but these are not connected with excel, so not active with my data.
You have to convert an SVG file to WMF, so that you can use shapes. Here is a nice tutorial:
http://www.clearlyandsimply.com/clearly_and_simply/2009/08/build-your-own-choropleth-maps-with-excel.html
If you want me to do it just let me know.
I was already there but I have no experience there, is it time consuming for you?
Yes, it is.
I see, what will it cost if I send the file and get it back with worldmap and I can workout more details.
Lets talk private you have my mail adress
Marco you can get ready mate maps for excel from the very nice website Clearly and Simply. If you google for chloropleth maps excel it will suggest this site: http://www.clearlyandsimply.com/clearly_and_simply/2009/06/choropleth-maps-with-excel.html