| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert bar in cell
Without creating a chart I would like to place a bar in a cell which reflects
the percentage of another cell. If I enter 45% in cell A1, how could I get a bar to reflect 45% in cell B1 without inserting a bar chart. I just want to see cell B1 45% filled. -- Lisa Fornal |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert bar in cell
How about this
=REPT(CHAR(149),INT(15*B1)) -- __________________________________ HTH Bob "Lisa F" wrote in message ... Without creating a chart I would like to place a bar in a cell which reflects the percentage of another cell. If I enter 45% in cell A1, how could I get a bar to reflect 45% in cell B1 without inserting a bar chart. I just want to see cell B1 45% filled. -- Lisa Fornal |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert bar in cell
=REPT(CHAR(8),A1)
"Lisa F" skrev: Without creating a chart I would like to place a bar in a cell which reflects the percentage of another cell. If I enter 45% in cell A1, how could I get a bar to reflect 45% in cell B1 without inserting a bar chart. I just want to see cell B1 45% filled. -- Lisa Fornal |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert bar in cell
Or maby
=REPT(CHAR(8),A1)&REPT(CHAR(7),100-A1) "Lisa F" skrev: Without creating a chart I would like to place a bar in a cell which reflects the percentage of another cell. If I enter 45% in cell A1, how could I get a bar to reflect 45% in cell B1 without inserting a bar chart. I just want to see cell B1 45% filled. -- Lisa Fornal |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert bar in cell
Thank you. I copied the formula and pasted it in B1. Just the formula
appears. I copied from = to the ). Could I do this through a FUNCTION? Do I need to place something in B1 before or after your formula? Before I sent this question I did a bar chart and was able to eliminate information and decrease the bar to the cell, but that was a lot of work. I figured there would be a simpler to the point process. -- Lisa Fornal "excelent" wrote: Or maby =REPT(CHAR(8),A1)&REPT(CHAR(7),100-A1) "Lisa F" skrev: Without creating a chart I would like to place a bar in a cell which reflects the percentage of another cell. If I enter 45% in cell A1, how could I get a bar to reflect 45% in cell B1 without inserting a bar chart. I just want to see cell B1 45% filled. -- Lisa Fornal |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert bar in cell
Dont u get a cind of bar in Cell B1 ?
try look at this http://pmexcelent.dk/Lisa.xls "Lisa F" skrev: Thank you. I copied the formula and pasted it in B1. Just the formula appears. I copied from = to the ). Could I do this through a FUNCTION? Do I need to place something in B1 before or after your formula? Before I sent this question I did a bar chart and was able to eliminate information and decrease the bar to the cell, but that was a lot of work. I figured there would be a simpler to the point process. -- Lisa Fornal "excelent" wrote: Or maby =REPT(CHAR(8),A1)&REPT(CHAR(7),100-A1) "Lisa F" skrev: Without creating a chart I would like to place a bar in a cell which reflects the percentage of another cell. If I enter 45% in cell A1, how could I get a bar to reflect 45% in cell B1 without inserting a bar chart. I just want to see cell B1 45% filled. -- Lisa Fornal |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert bar in cell
I opened your attachment. That is exactly what I got as a result. What I
would like is an actual bar like a bar chart shows. -- Lisa Fornal "excelent" wrote: Dont u get a cind of bar in Cell B1 ? try look at this http://pmexcelent.dk/Lisa.xls "Lisa F" skrev: Thank you. I copied the formula and pasted it in B1. Just the formula appears. I copied from = to the ). Could I do this through a FUNCTION? Do I need to place something in B1 before or after your formula? Before I sent this question I did a bar chart and was able to eliminate information and decrease the bar to the cell, but that was a lot of work. I figured there would be a simpler to the point process. -- Lisa Fornal "excelent" wrote: Or maby =REPT(CHAR(8),A1)&REPT(CHAR(7),100-A1) "Lisa F" skrev: Without creating a chart I would like to place a bar in a cell which reflects the percentage of another cell. If I enter 45% in cell A1, how could I get a bar to reflect 45% in cell B1 without inserting a bar chart. I just want to see cell B1 45% filled. -- Lisa Fornal |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert bar in cell
Here's a small sample file that demonstrates one method:
Progress bars.xls 15kb http://cjoint.com/?bcxbxpRyXs The cells with the bars are formatted to use the Webdings font. -- Biff Microsoft Excel MVP "Lisa F" wrote in message ... I opened your attachment. That is exactly what I got as a result. What I would like is an actual bar like a bar chart shows. -- Lisa Fornal "excelent" wrote: Dont u get a cind of bar in Cell B1 ? try look at this http://pmexcelent.dk/Lisa.xls "Lisa F" skrev: Thank you. I copied the formula and pasted it in B1. Just the formula appears. I copied from = to the ). Could I do this through a FUNCTION? Do I need to place something in B1 before or after your formula? Before I sent this question I did a bar chart and was able to eliminate information and decrease the bar to the cell, but that was a lot of work. I figured there would be a simpler to the point process. -- Lisa Fornal "excelent" wrote: Or maby =REPT(CHAR(8),A1)&REPT(CHAR(7),100-A1) "Lisa F" skrev: Without creating a chart I would like to place a bar in a cell which reflects the percentage of another cell. If I enter 45% in cell A1, how could I get a bar to reflect 45% in cell B1 without inserting a bar chart. I just want to see cell B1 45% filled. -- Lisa Fornal |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert bar in cell
You are awesome. This is exactly what I am needing. Thank you very much.
-- Lisa Fornal "T. Valko" wrote: Here's a small sample file that demonstrates one method: Progress bars.xls 15kb http://cjoint.com/?bcxbxpRyXs The cells with the bars are formatted to use the Webdings font. -- Biff Microsoft Excel MVP "Lisa F" wrote in message ... I opened your attachment. That is exactly what I got as a result. What I would like is an actual bar like a bar chart shows. -- Lisa Fornal "excelent" wrote: Dont u get a cind of bar in Cell B1 ? try look at this http://pmexcelent.dk/Lisa.xls "Lisa F" skrev: Thank you. I copied the formula and pasted it in B1. Just the formula appears. I copied from = to the ). Could I do this through a FUNCTION? Do I need to place something in B1 before or after your formula? Before I sent this question I did a bar chart and was able to eliminate information and decrease the bar to the cell, but that was a lot of work. I figured there would be a simpler to the point process. -- Lisa Fornal "excelent" wrote: Or maby =REPT(CHAR(8),A1)&REPT(CHAR(7),100-A1) "Lisa F" skrev: Without creating a chart I would like to place a bar in a cell which reflects the percentage of another cell. If I enter 45% in cell A1, how could I get a bar to reflect 45% in cell B1 without inserting a bar chart. I just want to see cell B1 45% filled. -- Lisa Fornal |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
insert bar in cell
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Lisa F" wrote in message ... You are awesome. This is exactly what I am needing. Thank you very much. -- Lisa Fornal "T. Valko" wrote: Here's a small sample file that demonstrates one method: Progress bars.xls 15kb http://cjoint.com/?bcxbxpRyXs The cells with the bars are formatted to use the Webdings font. -- Biff Microsoft Excel MVP "Lisa F" wrote in message ... I opened your attachment. That is exactly what I got as a result. What I would like is an actual bar like a bar chart shows. -- Lisa Fornal "excelent" wrote: Dont u get a cind of bar in Cell B1 ? try look at this http://pmexcelent.dk/Lisa.xls "Lisa F" skrev: Thank you. I copied the formula and pasted it in B1. Just the formula appears. I copied from = to the ). Could I do this through a FUNCTION? Do I need to place something in B1 before or after your formula? Before I sent this question I did a bar chart and was able to eliminate information and decrease the bar to the cell, but that was a lot of work. I figured there would be a simpler to the point process. -- Lisa Fornal "excelent" wrote: Or maby =REPT(CHAR(8),A1)&REPT(CHAR(7),100-A1) "Lisa F" skrev: Without creating a chart I would like to place a bar in a cell which reflects the percentage of another cell. If I enter 45% in cell A1, how could I get a bar to reflect 45% in cell B1 without inserting a bar chart. I just want to see cell B1 45% filled. -- Lisa Fornal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Discussion (Misc queries) | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
| Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
| how do I insert a cell based on its match with an adjacent cell? | Excel Worksheet Functions | |||
Linear Mode
