For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #37

This figure uses an Excel chart to link two columns of ranked data in a spreadsheet. Both the chart and data adjust automatically.

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

Charley's Swipe File #37This figure uses a chart to link two sets of ranked values in a table. Both the chart and table adapt automatically to changes in the data.

Formulas that Sort Automatically

The most important elements of this figure are the RANK, MATCH, and INDEX functions. These functions implement the automatic sorting.

You can see the formulas for yourself in the workbook, but you’ll need some explanation. 

In this figure...

(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 $14.95 USD

New Excel