For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #14

This high-quality dot-plot chart for Excel closely matches a chart from The Economist magazine. It can show results for any set of time periods.


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

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

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

This figure could be used nearly anywhere: Word, PDF, PowerPoint, HTML, or Excel. It could show data for any set of time periods.

Or, instead of dates, you could show categories of information like: three production methods, sales regions, departments, supervisors, vendors, and so on.

From the documentation for this swipe file...

This dot-plot chart is a New Excel version that closely matches a chart I found in The Economist magazine.

In the version for Classic Excel, I replaced the dots (circles) with squares because the circle markers in Classic Excel are ugly. But you can try both versions and see what you think.

Also, I used a red triangle decoration in Classic Excel rather than a rectangle. I made this change to bring a slight variation to the original design. Also, the triangle acts as a pointer that directs attention to the title of the figure.

So even if you use New Excel, take a look at the Classic Excel version.

This is a scatter plot that uses an advanced charting technique to label each row of dots. You’ll get a hint about this technique when you look at the SERIES formulas in this chart and see that there are four SERIES formulas, even though there are only three sets of points.

(Continued in the documentation.)

Order Details

Excel Versions:

Excel 2007 and after, for either Windows or Mac

Availability:

Instant download of zipped Excel and PDF files. If you ever need another download, you can get it at any time.

Guarantee:

One full year, unconditional.

Currency:

All prices are in US Dollar currency.

Licensing:

Two copies: One for work plus one for home.

Credit Cards:

Credit Cards
 

Only $9.95 USD

New Excel