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?

CodePudding user response：

Is there a way to do this on Google Sheets?

you can try like this: