Traffic Light Charts for Excel

We’ve looked before at add-ins for gauges and sparklines, but haven’t looked at “Traffic Light Charts”. These apply colour highlights to trends, as in the example left.

Here improvement is shown in green, and deterioration in red. The thicker red line is especially poor performance, and will jump out at anyone reviewing this simple dashboard. This and other styles are achieved using Excel add-ins.

If you like what you see, the add-ins can be purchased at reasonable prices from the foot of the page.

.