For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #12

The row titles in this professional-quality Excel chart use a little known method to left-justify chart titles and make them as long as you want.

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

Charley's Swipe File #12(All 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.

● Add the figure to an Excel report. To make the design fit with the rest of the page, use similar fonts for major titles, and a hint of similar colors.

From the documentation for this swipe file...

This simple figure offers several areas of interest.

First, I never would have chosen that background color if I were creating it from scratch. But thatís an accurate representation of the magazineís original color. Feel free to change it if you want.

More important, the row titles in the chart area use a technique that very few Excel Users know about. This technique offers two benefits for this chart.

The minor benefit is that it allows the titles to be left-justified. The major benefit is that it allows your titles to be as long as you want. This is in sharp contrast to the labels you normally can display in a chart.

Hereís the technique:

(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