Excel 2007 REPT formula

[johnny52]

I have the number 87 in cell a2

In cell b2 I use the formula =REPT("l",A2) and use 8 point Arial font to get a nice little bar graph

but...it there a way to compress the width of the output 87 takes up a lot of space in a cell.

I still need the bar graph to reflect the actual number 87 only a lot less width

I have a lot of rows with many different numbers ...hopes ther's a way to compress them all.

Thanks All......Mr Excel Rules !!!!!

 

[CWatts]

Perhaps change to Arial Narrow font and change the size.

I'd reccommend that you experiment with Excel 2007's Data Bars found under conditional formatting.

 

[shg]

I second CWATT's suggestion, but you can always scale the result, e.g.,

=REPT("l",A2/3)

 

[johnny52]

Both nice ideas.

It looks like the arial narrow font and some sizing will do the trick.

Thanks