For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #18

This professional-quality figure shows how to create mini charts, put date labels in small spaces, and convert Classic Excel to New Excel colors.

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

Charley's Swipe File #18(Most 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.)

This figure illustrates formatting issues that you'll probably face in your reports: Creating mini charts. Showing date labels in small spaces. Including units of measure. And, as I mention below, converting Classic Excel colors to New Excel colors.

Usage Ideas

This figure would work well in Word, PDF, and PowerPoint presentations.

From the documentation for this swipe file...

...I first created this figure in Excel 2003 then opened the workbook in 2010, which was a mistake for at least two reasons.

First, New Excel has more charting power than Classic Excel. So by creating the figure in Classic Excel I limited it to the lowest common denominator. In this particular case, that wasnít a problem. But itís something to keep in mind if youíre creating a figure to be used in both versions.

Second, when I opened the Classic Excel version in 2010 I ran into the Excel bug I discuss in my blog video Excel Color Compatibility Problems Between Classic and New Versions. So I ran this macro to fix the problem:

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

New Excel