Search code examples
excelgoogle-sheetschartsms-officespreadsheet

Excel - Dynamic pie chart linked to drop-down list


I want to create a pie chart that shows the status of a certain process (i.e. how many lines are "Done", how many are "In Progress", etc.)

I have a column that contains a drop-down list with the statuses that I'm working on, and now I want to create the chart that will update automatically when I change the status from "In Progress" to "Done".

Is there a way to do this on Excel/Google Sheets?


Solution

  • Is there a way to do this on Google Sheets?

    you can try like this:

    enter image description here