For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #34

The dynamic legend in this Excel chart figure sorts automatically so it's arranged in the same order as the most-recent period of data

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

This figure uses dynamic chart legends. I had a lot of fun setting it up; I hope you like it!

Charley's Swipe File #34As you can see in these two examples, the legend automatically adjusts to the current value in the chart. 

In the left version, for example, the best-selling product line is Slacks; but in the right version, itís Shirts.

Because the sample data uses random numbers, the legend bar changes each time the workbook recalculates.

I used conditional formatting to create the dynamic legend. Thatís a problem if you still use Excel 2003, however, because that version supports only three conditional formats per cell.

(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