Final Friday Fix: February 2021 Challenge

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you’re playing for bragging rights only!

This month, let’s have a play with a donut chart!

The Challenge

There is a donut chart created based on a group rating data set where the rating for each group ranges from one (1) to five (5) with an increment of one (1).

This chart has a colour conditional formatting for its series and legend. If the group ratings are changed, both the chart series and legend colour will also be adjusted accordingly.

We have created the chart for you. Your job is to get the ‘conditional legend’ working. To make it easier for you, we have prepared a start file here so that you can have a play.

Sounds easy? Then why not have a go? We’ll publish one solution in Monday’s blog. Have a great weekend in the meantime!