(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.)
a full-sized version of Charley's File #4. You can learn more about it
after the figure.
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.
Use this type of display to compare the same measure for many categories
of performance. You could use it for products, divisions, departments,
vendors, customers, web pages, sales regions, countries, and so on.
The unit of measure could be percentage change, your currency, number of
visitors, number of days, headcount, a measure of weight, profit margin,
return on investment, etc.
From the documentation for this swipe file...
This display shows three dimensions of data. For each of 12
entities (dimension 1) it shows trends in the values (dimension 2)
of the same measure over time (dimension 3).
Unlike typical dashboard reports, all charts
have the same X and Y axis values. This easily allows you to compare
the relative performance of many measures.
In The Visual Display of Quantitative
Information, Edward Tufte called displays like this "small
Later, William Cleveland coined the term
"trellis displays". Others call them "panel charts".
Whatever you call them, displays like this
can help you to better understand your three-dimensional data.
The greatest challenge in producing displays
like this is to handle the axis labels effectively in Excel. I
worked for a long time to find the best way to do this. Here’s the
final design approach:
(Continued in the documentation.)
Get this Excel workbook now!
I'm never satisfied unless you are more than satisfied.
So here's my simple "no Small Print" guarantee. Try my swipe
file today and put it through the ringer. Use it in your
reports and presentations for 12 months.
You be the judge. If my workbook doesn't deliver everything
I've promised, or if you're unhappy with it for any reason,
just let me know and I'll immediately give you your money
I have no problem making this iron-clad guarantee because
I've used Excel from day 1; so I
know my techniques work. Fair enough?
One work copy plus one personal copy.
Classic Excel or New Excel
Visa, Mastercard, American Express, Discover, PayPal
|Only $17.95 USD
||Only $17.95 USD