For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Learn Excel Charting Tricks while Giving Your Managers,
Customers, & Clients Professional Excel Figures Like These

This is the largest collection of professional-quality Excel charts in the world. And you can get them all!


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

These are Excel figures in ordinary workbooks. They offer a quick and inexpensive way to create professionally designed figures for Excel, Word, PowerPoint, PDFs, and the Web...and to learn how to create your own high-quality charts from scratch.

Each figure comes with two sets of documentation, an eight-page "Getting Started" PDF file, and a two-page PDF file about the figure. So you can learn what it takes to create great-looking Excel figures.

Files 1-50 are available for all versions of Excel, PC or Mac, from Excel 97 through Excel 2013. Beginning with file 51, files are available only for Excel 2007 and after, for the PC or Mac.

Click an image below to see a larger version, to learn more about the chart, and to see how to get the working chart for yourself.

<< See Charley's Files 1-44

45 46 47 48
Charley's Swipe File Chart #45 Charley's Swipe File Chart #46 Charley's Swipe File Chart #47 Charley's Swipe File Chart #48
49 50 51 52
Charley's Swipe File #49, using many Excel chart tricks Charley's Swipe File Chart #50 Charley's Swipe File #51 Charley's Swipe File Chart #52
53 54 55 56
Charley's Swipe File Chart #53 Charley's Swipe File Chart #54 Charley's Swipe File Chart #55 Charley's Swipe File Chart #56
57 58 59 60
Charley's Swipe File #57...An Excel 100% Column Chart from 'The Economist' Charley's Swipe File #58...An Excel Histogram Chart from 'The Economist' Charley's Swipe File #59...A grouped-column chart using five SERIES formulas, based on a 'Wall Street Journal' chart. Charley's Swipe File #60...A grouped-column chart using one SERIES formula, based on a 'The Wall Street Journal' chart.
61 62 63 64
Charley's Swipe File #61...An Excel breakeven chart Charley's Swipe File #62...Two Excel implementations of Stephen Fews Bullet Charts Charley's Swipe File #63...Use formulas to display colored dots in the scorecard. Charley's Swipe File #64...A replacement for Excel's stacked column charts.
65 66 67 68
Charley's Swipe File #65...Small-multiples Excel charts with reference lines. Charley's Swipe File #66...Chart of actual performance with multiple forecasts Charley's Swipe File #67...Chart showing employment seasonality of male workers by age group Charley's Swipe File #66...Three-panel chart figure
69 70 71 72
Charley's Swipe File #69...Mini-dashboard with quarterly and daily data. Charley's Swipe File Chart #71...The DuPont Dashboard Charley's Swipe File Chart #72...Chart of top and bottom performers.
73 74 75 76
Charley's Swipe File Chart #73...Using a bar chart as a legend. Charley's Swipe File Chart #74...Explaining performance in charts. Charley's Swipe File Chart #75...Excel dot chart. Charley's Swipe File Chart #76...Excel panel chart.

<< See Charley's Files 1-44