For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #68

From a figure in The Economist, this makes a great display for Word, PDF, and PowerPoint slides. The workbook also includes a random trend generator.

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

From a figure in The Economist, this makes a great display for†Word, PDF, and PowerPoint slides. The workbook also includes a random trend generator.This figure is based on one that appeared roughly 20 years ago in The Economist magazine.

It's probably is better suited for a Word or PDF report, or a PowerPoint slide, than for an Excel report. Even so, it illustrates useful elements that most of your Excel chart figures should contain.

The Artificial Data

The data shown was generated by a random-number formula that Iíve used for years to simulate artificial trends as I develop new charts and reports when real data isnít available.

In these Swipe files, I normally convert the artificial trends to values. To do so, I select the range I want to convert to values, press Ctrl+C to copy it, then choose Home, Clipboard, Paste, Paste Values, Values. But this time, I left the formula in the workbook. Here it is:

(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 $13.95

New Excel