Creating a comparative histogram

Book cover This article is an excerpt from Excel 2007 Charts by John Walkenbach. A.k.a. Mr. Spreadsheet, John is arguably the foremost authority on Excel. His forty-plus books include Excel 2007 Power Programming with VBA, Excel 2007 Formulas, and the bestselling Excel 2007 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pack. Visit to learn more about this book.

A comparative histogram, sometimes known as a population pyramid chart, compares two sets of data using horizontal bars. Although this type of chart is often used with population data, it can be used in a variety of other situations.

Read Article button

Applies to:
Excel 2007