RE: 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
.

Relevant Pages

  • Re: insert bar in cell
    ... would like is an actual bar like a bar chart shows. ... "Lisa F" skrev: ... Before I sent this question I did a bar chart and was able to eliminate ... the percentage of another cell. ...
    (microsoft.public.excel.misc)
  • RE: insert bar in cell
    ... Lisa Fornal ... "Lisa F" skrev: ... 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. ...
    (microsoft.public.excel.misc)
  • Re: Is it possible?
    ... That means, you must *either* click in the formula bar, ... Click in a cell containing the formula. ... Regards, ... > Although I have performed CSE, I do not see the curly brackets in the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Understanding # and function variables
    ... If FOO is lexically bound, ... the value cell of the symbol FOO will ... BAR is now considered a special variable everywhere. ... symbol BAR and temporarily modifies it to be 5000. ...
    (comp.lang.lisp)
  • Re: How do I create very small graphics in ONE cell?
    ... be easily extended to show a bar chart using multiple columns. ... The first part of the code goes in the worksheet module. ... Dim x As Shape ... > the numbers in ONE cell so that people can quicky scan through the trend. ...
    (microsoft.public.excel.charting)