Hi,
I would like to create a daily schedule with Checkboxes and I would like to visualize it with a progress bar - if checkbox clicked it gets more filled - if all checked its all single colored.
What kind of formulas I should use? I assume I need the data table + a table where I can ad the formulas but not really sure how can I get there.
Thank for the help!
MacBook Pro Retina
You can do something like this:
the table in this example should have a single header row and two footer rows.
the first cell in the footer of the column that has the checkboxes (in this example cell C11) should have the formula:
=ROWS(C)−3
shorthand is:
C11=ROWS(C)−3
C12=COUNTIF(C, TRUE)/C$11
select cell C12 then add a bar chart:
While the chart is selected, use the chart formatter to change the range to be 0 for the Min and 1 for the Max
You can do something like this:
the table in this example should have a single header row and two footer rows.
the first cell in the footer of the column that has the checkboxes (in this example cell C11) should have the formula:
=ROWS(C)−3
shorthand is:
C11=ROWS(C)−3
C12=COUNTIF(C, TRUE)/C$11
select cell C12 then add a bar chart:
While the chart is selected, use the chart formatter to change the range to be 0 for the Min and 1 for the Max
Progress bar with Checkboxes in Numbers
