How to Make a Dynamic Multi-population Pyramid in Excel
Create better population pyramids that allow for improved comparisons between sexes and populations.
If you want to select a chart that is also an iconic representation of a field of knowledge, it’s hard to come up with a better example than a population pyramid. It is a simple way of visualizing a population structure by age and sex, which is a great starting point to learn about a region.
However, the traditional design can be improved. In this tutorial, you’ll create a population pyramid that displays the structure of the population in three different moments (1950, 2025 and 2100), something that the traditional design can’t handle well.
To access this full tutorial and download the source code you must be a member. (If you are already a member, log in here.)
Get instant access to this tutorial and over a hundred more, plus courses, guides, and additional resources.
You'll get unlimited access to hundreds of hours worth of step-by-step visualization courses and tutorials for insight and presentation — all while supporting an independent site. Source code and data is included so that you can more easily apply what you learn in your own work.
The tutorials are very helpful to move from "Oooo, cool!" to how to actually DO the cool.
Members also recieve a weekly newsletter, The Process. Keep up-to-date on visualization tools, the rules, and the guidelines and how they all work together in practice.
See samples of everything you gain access to:
More Tutorials See All →
How to Make a Sankey Diagram to Show Flow
These tend to be made ad hoc and are usually pieced together manually, which takes a lot of time. Here’s a way to lay the framework in R, so you don’t have to do all the work yourself.
How to Edit R Charts in Adobe Illustrator
A detailed guide for R users who want to polish their charts in the popular graphic design app for readability and aesthetics.
How to Make a State Grid Map in R
Something of a cross between a reference table and a map, the state grid provides equal space to each state and a semblance of the country to quickly pick out individual states.