For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #23

The professional-quality Excel charts in this figure do a great job of displaying ranked data when both positive and negative performance exists.


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

Charley's Swipe File #23These days, the Wall Street Journal seems to have the most interesting displays of data. This is another of their displays, which showed how airline rates were fluctuating.

The figure does a great job of displaying ranked data when both positive and negative performance exists.

Although this figure loses some of its appeal if all performance is either positive or negative, it still would work for that purpose.

Usage Ideas

You could use this figure to show the relative performance of a short list of entities: products or product lines, sales regions, cost categories, and so on.

Excel Issues

There are several Excel challenges to this figure. Here are their solutions:

The legend text for each row is in the spreadsheet behind the chart. Simple formulas determine whether to display the text, depending on the sign of the data.

The gray lines between each bar or label are chart gridlines, not cell borders. To fit the bars so they exactly touch the gridlines, I set the Gap Width in the barsí Series Options tab to...

(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 $14.95 USD

New Excel