Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.charting,microsoft.public.excel
|
|||
|
|||
Progress bar in spreadsheet?
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 .. |
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.charting,microsoft.public.excel
|
|||
|
|||
Progress bar in spreadsheet?
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...ht=conditional Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "RBear3" 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 . |
#3
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.charting,microsoft.public.excel
|
|||
|
|||
Progress bar in spreadsheet?
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" wrote in message ... 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...ht=conditional Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "RBear3" 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 . |
#4
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.charting,microsoft.public.excel
|
|||
|
|||
Progress bar in spreadsheet?
You have already had some good suggestions.
One of my old blog posts may be of help. Look at http://www.edferrero.com/Blog/tabid/...1/Default.aspx and scroll about half way down - to More on Excel 2007 Conditional Formats (and Excel 2003) My blog is a little bit broken at the moment, sorry, but this should get you there. Ed Ferrero www.edferrero.com |
#5
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.charting,microsoft.public.excel
|
|||
|
|||
Progress bar in spreadsheet?
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" 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 .. |
#6
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.charting,microsoft.public.excel
|
|||
|
|||
Progress bar in spreadsheet?
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 . |
#7
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.charting,microsoft.public.excel
|
|||
|
|||
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 . |
#8
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.charting,microsoft.public.excel
|
|||
|
|||
Progress bar in spreadsheet?
You will need to set the column width to the 100% size. Also, you can
use Niagara Solid or Stencil fonts to create a solid line. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Progress bar in spreadsheet? | Excel Worksheet Functions | |||
Progress Bar | Excel Discussion (Misc queries) | |||
PROGRESS BAR | Excel Discussion (Misc queries) | |||
Progress bar | Excel Discussion (Misc queries) | |||
Progress YTD | Charts and Charting in Excel |