Forum Discussion
Office dashboard with progress bar
Hey,
I am trying to create an Excell workbook which lists all the tasks we have to complete on a yearly basis. I would like to be able to thick a box once a job is completed and have a general ...
Hello,
instead of tick boxes, I suggest just using a "yes" or "no" text. Tick boxes are intended for forms with VBA code behind and don't translate well to a spreadsheet grid.
If the data about a task's status is somewhere in a different sheet, you may be able to use formulas to automatically fill the "yes" or "no".
Once this helper column is in place, you can then count the "yes" cells in the column and subtract it from the total count of tasks (which are not yet complete). With these two values you can build a horizontal stacked 100% chart.