1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Pie Chart from Dropdown List for Completion

Hey there! I'm currently trying to make a pipeline chart for my short film and general organization, and I want to insert a pie chart based on the completion rate of different parts of the pipeline, but I'm extremely new to excel and everything I've tried from others questions hasn't panned out.

I want to make a pie chart that shows the level of completion (Pending, WIP, In Review, Complete) for each episode, (horizontal), with each color(name) being a different slice.

The items for the dropdown are on a separate sheet called List Items.

((Also if anyone knows how to make it a percentage thing that would be awesome))

https://preview.redd.it/jyjnrfnafr3h1.png?width=322&format=png&auto=webp&s=5bbf884827c8dd46b91bb8a68f1f0f7124c810ef

https://preview.redd.it/qpylsgaafr3h1.png?width=2406&format=png&auto=webp&s=94c389f5f421ed2a67144bfb83821cd8029bc862

https://preview.redd.it/72egzj1bfr3h1.png?width=2296&format=png&auto=webp&s=c627b52d650b402e4321bd49ab341467d6a8ab3a

submitted by /u/INeedAHuman_POW
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#enterprise-level spreadsheet solutions
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#pie chart
#Excel
#completion rate
#pipeline chart
#percentage
#dropdown list
#Pending
#WIP
#In Review
#Complete
#visualization