For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #15

This set includes two workbooks. The line shows actual performance. Then one chart shows possible upside results; the other shows downside results.

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports
Charley's Swipe File #15a Charley's Swipe File #15b
(Many of my swipe files use Greeking, which is fake Latin. It helps you ignore the textual content and focus on the actual charts and tables.)

Each set of swipe files comes with two PDFs for documentation: a general, eight-page "Getting Started" document, and a two-page document specific to the current swipe file.

Usage Ideas

These figures would be great in any display, including Word, PDF, PowerPoint, and Excel. You could use them to explain the effect of both past and forecasted changes.

For example, the figure could say, in effect, “Here is how recent changes have affected performance.” Or, looking ahead, the figure could say, “Here is how planned changes will affect projected performance.” The “changes” could include new products or customers, new or reduced spending, new marketing methods, and so on.

From the documentation for this swipe file...

This set of swipe files includes two workbooks for each version of Excel.

The line in both figures shows actual performance until early 2010. Then each line shows what the trend is projected to be if no improvements are made.

The first figure shows an up-is-good situation; and the four area plots show four ways to improve that performance.

For example, the line could represent revenue and the area plots could show projected sales from four new products.

The second figure shows a down-is-good situation. For example, the line could represent expenses and the four area plots could show project cost savings.

Both figures rely on the same trick to display their data:

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

New Excel