These are three free video tutorials that I’d like to share with you. They will show you step by step what you need to do to create a choropleth (thematic) map in Excel, several ways to make a population pyramid and a non-designer approach to create a new palette for your Excel charts. Enjoy!
It’s amazing what you can do in Excel with shapes and a small amount of VBA. This tutorial shows you how to use shapes you can import from several sources to create a simple map. It is not intended to replace a professional geographic information system, but if you just need a basic map to add to your presentation this will do the trick.
Population studies rely heavily in the analysis of population structures, and a population pyramid is almost an icon for these studies. I actually don’t like the regular chart, so what I show here is a “folded” pyramid that allows you to see the age structure but also makes sex comparisons easier.