For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #3

The dark border for the area plot in these charts is a line plot. We can't use the Border property because area-plot borders surround the area plot.

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

This Excel figure is inspired by Business Week. It shows performance for two measures using a professional-quality design.(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

 Use the figure in Word, PDF, or Web documents.
 Use it in PowerPoint slides, perhaps with changed dimensions.
 Add the figure to an Excel report. To make it fit with the rest of the page, use similar fonts and the dark red color for major titles.
 To display categories of information, rather than trends, change one or both of the charts to a column chart.

From the documentation for this swipe file...

Youíll find two versions in this set. One shows 13 months and the other shows three years.

The two versions are basically the same. But they illustrate several differences that youíll find useful when you change your version of these figures.

In all cases, the dark border shown for the area plot is produced by a line plot. We donít use the Border property because borders surround the area plot; they arenít confined to the top edge.

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

New Excel