Waffle Chart Tutorial|Dashboards & Charts|Excel Forum|My Online Training Hub

I have been working with the waffle chart video using the US Senate data. I followed the setup steps in the video. However, when I get the first rule set up I get the entire grid set to red. When I continue and set up the rule for the second data (Democrats) I get the waffle chart set up with the red cell at the top and the rest of the chart in blue. Not sure what is going on. I am using Excel 365.

I have attached the file with the rule set up and the resulting chart displayed.