Solutions and training for business users of Microsoft Excel.
 

Catalog   

< Previous Swipe File  |  Next Swipe File >

Charley's File #42

Charley's Swipe File #42This set of Swipe Files contains several figures in one.

This figure shows growth in real domestic product by state for the top-and bottom-three states. Another figure uses the same format to show growth in per capita personal income by state for the top- and bottom-three states.

If you have KydWeb, you can download new data with one of the workbooks in this set. Otherwise, you can use the other two workbooks to chart static data values for each figure.

Usage Ideas

You can adapt these charts to show top- and bottom-ranked performance of just about anything: products, sales people, vendors, whatever.

Or, you could use the same set of charts to display the growth in any measures of performance. But rather than manually setting the green and red fills to signal good and bad performance, you could set conditional formats to do the same thing. This would let you arrange the charts in any order and use the color codes to alert readers to extreme performance.

One unusual thing about these figures is that the rankings are determined by formula. So as the data changes, the rankings adjust as needed.

(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 back.

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?
Summary  
Availability:
Guarantee:
Licensing:
File Format:
Credit Cards:
Instant download.
One-year, unconditional.
One work copy plus one personal copy.
Classic Excel or New Excel
Visa, Mastercard, American Express, Discover, PayPal
 
Only $16.95 USD Only $16.95 USD

 


ExcelUser, Inc.
http:///www.ExcelUser.com

Copyright © 2004 - 2012 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. Terms of Use | Privacy Policy | Earnings Policy.