•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Checkboxes linked to a percentage pie chart
Hello,
I'm trying to make a percentage completion pie chart for a simple to-do list in excel. Basically, I have a row for each task, and two columns, one is a description of the task and the other is a checkbox.
I know how to create the pie chart showing a percentage of how many boxes are checked out of the 24 that exist, but many of those task rows are left blank until filled with a task. So how do I make it only account for the checkboxes that have tasks associated with them?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#row zero
#checkbox
#percentage
#pie chart
#completion
#excel
#task
#checked
#to-do list
#boxes
#description
#associated
#row
#column