View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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