Chart in Dashboards


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
    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.