For business users of Microsoft Excel Free guides and templates

Windows & Mac Excel

Charley's Swipe File #36

The Profit-Loss legend and the black and red dots in the transparent columns make this Excel chart figure distinctive.

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

Charley's Swipe File #36Two characteristics make this chart figure particularly distinctive.

First, the figure displays profits with black dots in a semi-transparent gray column, and losses with red dots in a semi-transparent pink column.

Second, the profit/loss indicator looks nothing like traditional chart legends in Excel.

How to Set Up the Dots and Columns

Excel users frequently ask how to chart positive numbers with one color and negative numbers with another. This is a problem, because Excel doesn’t provide that setting by default.

But a simple trick makes this easy to do: You set up... 

(Continued in the documentation.)

Order Details

Excel Versions:

Excel 2007 and after, for either Windows or Mac


Instant download of zipped Excel and PDF files. If you ever need another download, you can get it at any time.


One full year, unconditional.


All prices are in US Dollar currency.


Two copies: One for work plus one for home.

Credit Cards:

Credit Cards

Only $12.95 USD

New Excel