Summarise checked vs unchecked boxes
I have an agenda sheet with followup items for a meeting. When the followup items are complete, a user ticks a checkbox.
On a dashboard for presentation at the next meeting, I want to create a stacked column graph that shows total follow-up tasks split into checked and unchecked.
I have the data available in a report like this:
I want a graph that looks like this:
How can I do this?