Progress bar in spreadsheet?
in [Charts]
|
From: RBear3 on 18 Jun 2008 09:03 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 ..
From: Andy Pope on 18 Jun 2008 09:32 Hi, You can not partial shade a single cell. What you can do is use multiple cells with some conditional formatting. Have a look at a recent post of my on another forum. http://www.excelforum.com/showthread.php?t=646509&highlight=conditional Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "RBear3" <rbear3(a)nospam.com> wrote in message news:eOd7mOU0IHA.4364(a)TK2MSFTNGP02.phx.gbl... >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 > . > >
From: Jim Cone on 18 Jun 2008 09:42 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" <rbear3(a)nospam.com> 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!! -- RBear3 ..
From: Pete_UK on 18 Jun 2008 09:55 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" <rbe...(a)nospam.com> 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 > .
From: Andy Pope on 18 Jun 2008 10:23 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Andy Pope" <andy(a)andypope.info> wrote in message news:287C1E31-3F18-42BD-820D-87BF6FE67BB3(a)microsoft.com... > Hi, > > You can not partial shade a single cell. What you can do is use multiple > cells with some conditional formatting. > > Have a look at a recent post of my on another forum. > http://www.excelforum.com/showthread.php?t=646509&highlight=conditional > > Cheers > Andy > > -- > > Andy Pope, Microsoft MVP - Excel > http://www.andypope.info > "RBear3" <rbear3(a)nospam.com> wrote in message > news:eOd7mOU0IHA.4364(a)TK2MSFTNGP02.phx.gbl... >>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 >> . >> >> >
|
Next
|
Last
Pages: 1 2 Prev: provide value to data series from named range Next: save chart as template |