Progress bar in spreadsheet?

  • Thread starter Thread starter RBear3
  • Start date Start date
R

RBear3

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!!
 
Another way...
You can use a formula to show a simple bar whose length varies
depending on the value in a cell.
If the value 28 is in cell B5, then try this formula in C5...
=REPT("n",B5/4).
Assign the Wingdings font to cell C5 and adjust the font size.
Customize as desired.
--
Jim Cone
Portland, Oregon USA



"RBear3"
<[email protected]>
wrote in message
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!!
 
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
 
Seeing the other guys suggestions of using the REPT function I thought I
better clarify my statement, "You can not partial shade a single cell".
Using the built-in Cell Shading you can not partial shade..

Cheers
Andy
 
Back
Top