•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
Our take
Managing tasks can feel overwhelming, especially when visualizing your progress seems complicated. If you're looking to create a percentage completion pie chart in Excel that accurately reflects only the tasks you’ve assigned, you’re in the right place. By linking your checkboxes to a dynamic formula, you can ensure that your chart reflects true completion without counting empty rows. Read on to discover a straightforward method to transform your to-do list into an effective progress tracker that motivates and keeps you focused.
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]
Read on the original site
Open the publisher's page for the full experience