Chart in Dashboards

randall.vanbemmel67451

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 : )

Paul Newcome

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.