For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #63

This Three-Dot Excel Scorecard allows either formulas or manual entries to determine when to display three colored dots in a list.


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

This Excel scorecard displays one of three colored dots in a list.This Three-Dot Scorecard allows formulas to determine whether to display a colored dot for each item.

The list of items could contain customers, or employees, or products, and so on. (But here, it uses Greeking, which is fake Latin.) And the dots indicate whether certain conditions exist.

The display also could serve as a checklist that marks whether certain steps have been taken or milestones reached.

You could, of course, replace the formulas with a manual entry of 1 or 0, as shown in the workbook’s Manual Report worksheet. And you could display any number of columns of dots.

Unlike most of my other Swipe Files, this figure uses only a formatted worksheet; no chart object is involved.

This worksheet involves two slightly unusual Excel features: the CHAR function and grouped objects. Let’s take a closer look at them…

(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

New Excel