For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #58

Use this Excel chart of two frequency distributions葉wo histograms葉o compare the performance of two similar entities...men vs women, North vs South, Texas vs California, etc.


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Charley's Swipe File Chart #58A frequency distribution is a summary of measures organized to show their frequency of occurrence.  The chart of this data is called a histogram.

These histograms, based on a chart from The Economist, compare the unemployment rates of Texas and California.

Similar histograms could compare orders by product by month for two sales people, failure rates by month for two products, the number of sick days taken by age by gender for the past year, and so on. The Economist showed the distribution of ages in the US by ethnic background.

To create charts like this in Excel, the first step is to create the frequency distribution table. For information about how the formulas in the table work, see my ExcelUser article, Use COUNTIFS, Not FREQUENCY, to Calculate Frequency Distribution Tables for Charting Histograms. You can see the formulas I discuss in that article used in this Swipe File.

One unusual aspect of the chart is its legend at the top right. The legend relies on Excel痴 Camera tool, also known as a linked picture.

Another unusual aspect is the back-to-back presentation of the bars. Setting this up requires four steps. First...

(Continued in the documentation.)

Order Details

Excel Versions:

Excel 2007 and after, for either Windows or Mac

Availability:

Instant download of zipped Excel and PDF files. If you ever need another download, you can get it at any time.

Guarantee:

One full year, unconditional.

Currency:

All prices are in US Dollar currency.

Licensing:

Two copies: One for work plus one for home.

Credit Cards:

Credit Cards
 

Only $14.95

New Excel