Checkboxes as a Visualisation in Excel

I have covered checkboxes as an interface in a previous post.

In the image below I have entered a formula in column D that displays either TRUE or FALSE depending on whether the score is greater than or equal to the target. A score above or equal to the target will return TRUE – that’s good.

I learned recently in a webinar presented by Ann K Emery that the checkbox can be applied to a range to display a ticked or unticked checkbox. This becomes a data visualisation tool.

In the image below I have selected the range D2 to D8, clicked on the Insert ribbon tab and selected the Checkbox option.

As you can see the ticked and unticked checkboxes have been applied to the range and so has the format that hides the underlying TRUE/FALSE results.

Clicking the checkboxes has no effect because they are controlled by the underlying formula. They only update if the scores or target change.

In the image below I have changed some of the scores and you can see the checkboxes have automatically updated.

If you need a quick visual to show a ticked or unticked checkbox across a range, then applying checkboxes is the way to go.