Chart in Dashboards

Hello,
Thanks to all for the wonderful help in the community! It makes everything so easy to use! I do have a question about something I was not able to figure out. I want to make a pie chart in a dashboard that reflects the status column in my sheet. Literally all I need it to do is have "Not Started, In Progress, Complete, Overdue" and show how many task fall into each bucket. If it could show the numbers as a percent that would be a bonus. Every time I try to do this, it tells me I need a numeric value to make a pie chart... I'm stumped!
Thanks : )
Comments
-
You will need to create a table with the counts for each status. Something like below (column headers in bold):
Β
StatusHΒ Β Β Β Β Β Β Β Β Β Count
Not StartedΒ Β Β Β Β Β Β formula
In ProgressΒ Β Β Β Β Β Β formula
CompleteΒ Β Β Β Β Β Β Β formula
OverdueΒ Β Β Β Β Β Β Β Β formula
Β
In the Count column you can enter
Β
=COUNTIFS([Status Column Name]:[Status Column Name], StatusH@row)
Β
This can also be used with cross sheet references.
Β
To build the pie chart, simply reference the cells in your new table and call it a day. This will also automatically update the counts as things change.