For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #42

Excel formulas rank the data automatically to allow six column charts to show states with the top and bottom performance 

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

Charley's Swipe File Chart #42This set of Swipe Files contains several figures in one.

This figure shows growth in real (that is, inflation-adjusted)domestic product by state for the top-and bottom-three states. Another figure uses the same format to show growth in per capita personal income by state for the top- and bottom-three states.

Usage Ideas

You can adapt these charts to show top- and bottom-ranked performance of just about anything: products, sales people, vendors, whatever.

Or, you could use the same set of charts to display the growth in any measures of performance. But rather than manually setting the green and red fills to signal good and bad performance, you could set conditional formats to do the same thing. This would let you arrange the charts in any order and use the color codes to alert readers to extreme performance.

One unusual thing about these figures is that the rankings are determined by formula. So as the data changes, the rankings adjust as needed.

(Continued in the documentation.)

Order Details

Excel Versions:

Excel 2007 and after, for either Windows or Mac


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


One full year, unconditional.


All prices are in US Dollar currency.


Two copies: One for work plus one for home.

Credit Cards:

Credit Cards

Only $16.95 USD

New Excel