Showing percentage progress pictorially
Posted by Gerry Anderson on August 11, 2000 3:30 PM
I used to have a spreadsheet for tracking progress of certain activities (drawing production for instance). Whoever was responsible for the activity would enter in one column alongside that activity their percentage progress. This would then display in the next column cell a "progress bar" whcih looked similar to for instance the volume bar on a hifi. If progress was say 50% then half of the cell would be shaded, 75% three quarters of the cell shaded and so on.
Does anyone know the formula/ macro for setting this sort of feature up.