Progress bar in spreadsheet?
Thanks! All of these suggestions are helpful.
--
RBear3
..
"Pete_UK" wrote in message
...
You could achieve this in an adjacent column - assuming your
percentage is in A1, then put this in B1:
=REPT("|",100*A1)
Format the cell to, say, Red, and copy down.
You could apply conditional formatting to have, say, Blue with the
formula =A1=0.75, and Green with =A1=0.5 and Yellow with A1=0.25,
so that the colour changes with progress of the project.
Hope this helps.
Pete
On Jun 18, 2:03 pm, "RBear3" wrote:
I am creating a spreadsheet where I will have a long list of projects. One
column represents the completion percentage for the project. I'd like to
display this as a progress bar. If the project is 50% complete, I want the
left half of the cell to be colored in. If it is 75% complete, I want the
left 3/4 of the field to be filled in, etc.
I don't mind doing this manually if there is a way to do so, but I figured
there might be some type of control that can do this.
I have seen reports built in accounting packages and "dashboard" or
"metric
tracking" applications that do similar visual representations for
individual
line items on reports.
Thanks for your suggestions!!
--
RBear3
.
|