For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #49

Nearly every element in this Excel chart uses a display or formatting trick: the title, the recession shading, the markers, the text-box legend, etc.

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

Charley's Swipe File #49Virtually every element of this figure uses a display or formatting trick.

  • The title and the Y-axis label use Excel’s rich text feature to display two font formats in the same cell.
  • The grayish recession indicator uses a column plot.
  • The dots that mark the current and year-old data use point-specific markers.
  • The legends use dynamic text in rectangle objects.
  • And the X-axis labels rely on text formulas to create the date formats shown.

More about the Tricks

Let’s take these tricks one at a time…

In the title, the first three words use Century Gothic 16, bold. The rest of the text uses Century Gothic 13, standard. To set this up, first assign one of the formats as you normally would. In the formula bar...

(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