number to bar graph in cell

[psrs0810]

I came across this formula =REPT(Text, Number_times) and if I use "|" it will repeat that number of times.
Where if found this, it looks like a solid bar graph in the cell. when i used it, there looks like some spacing between each |. is there some formatting that I am missing? Is there a way to eliminate spaces or reduce spacing?

thanks

 

[VoG]

You would be better off using *

 

[psrs0810]

I like the |, it makes the information into a nice bar graph. I just don't know why my has some spacing and the original report does not

 

[psrs0810]

I think I see why. it's the magnification. the original report reducted the magnifaction, making the |'s look grouped together.

 

[Steve=True]

It may also be your font.

Some people use different fonts and different font sizes to make the Bar's look better.

Also you can use different char() characters to find better blocks.


Steve=True
www.exceldashboardtemplates.com

 

[dave3009]

You can also use full block character for this

█

 

[psrs0810]

where may I find this?

 

[dave3009]

Just copy it from my post and use it in your formula

=REPT("█", 10)

 

[psrs0810]

nice!
thanks for everyones help. I also found some good info on: http://www.juiceanalytics.com/writing/more-on-excel-in-cell-graphing/

 

[dave3009]

.