I learnt a cool new trick in PowerPoint yesterday. I learnt about merging shapes.

Like Excel, PowerPoint has the ability to draw various shapes into your slides (or sheets in Excel). We can draw lines, arrows, rectangles, circles and many other shapes.

But PowerPoint has an extra feature with shapes that isn’t available in Excel. In PowerPoint, we have the ability to merge shapes together to create new shapes.

We could combine a long skinny rectangle with a star shape to create a magic wand. The Possibilities are endless!

That gave me an idea for a fancy dashboard type visual. So in this post, we’re going to learn how to create a dynamic traffic light that changes colours based on some key performance indicator (KPI) value in our dashboard.

Traffic-Light-Dashboard-Visual Create A Dynamic Traffic Light Visual For Your Excel Dashboards