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, you must be a member. (If you are already a member, log in here.)
Get instant access to this tutorial and hundreds more, plus courses, guides, and additional resources.
You will get unlimited access to step-by-step visualization courses and tutorials for insight and presentation — all while supporting an independent site. Files and data are included so that you can more easily apply what you learn in your own work.
Learn to make great charts that are beautiful and useful.
Members also receive 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 Stacked Area Charts in R
From the basic area chart, to the stacked version, to the streamgraph, the geometry is similar. Once you know how to do one, you can do them all.
Loading Data and Basic Formatting in R
It might not be sexy, but you have to load your data and get it in the right format before you can visualize it. Here are the basics, which might be all you need.
How to Make an Interactive Map of Geographic Paths
With latitude and longitude coordinates, there are a number of ways to map geographic data using D3.js and Leaflet.