For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #35

This chart, based on one from the Wall Street Journal, offers several enhanced legends you can set up in Excel

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

Charley's Swipe File #35This is another Excel chart based on a chart from the Wall Street Journal. It offers several enhanced types of chart legends.

The labels all use textboxes. The labels at the right of the figure are linked to spreadsheet cells and update as the calculated data changes.

You could, of course, link all the textboxes to spreadsheet cells.

General Excel Issues

The numbers in the legend boxes show the change in unemployment rates during the previous 24 months. The WSJ used two methods in the chart to highlight this period.

First, it shaded the most-recent 24 periods. This is easy to do. You just...

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

New Excel