Creating horizontal bar charts by repeating a symbol? [SOLVED]

[Denko]

I saw this once, but now that I have an opportunity to do it, I can't remember how it was done. I have a series of numbers and I want to create a bar chart by repeating a character. Like this:


A B

10 ||||||||||

20 ||||||||||||||||||||

25 |||||||||||||||||||||||||


And so on. So I need a formula in A2 that says, "|" x A1. Does anyone know how to write a formula that repeats a symbol?


Thanks.


Dan

 

[keymaster]

rept ofcourse... here is a tutorial.. http://chandoo.org/excel-formulas/rept.html

more examples here: http://chandoo.org/wp/2008/05/13/creating-in-cell-bar-charts-histograms-in-excel/

 

[LesEwing]

Hi Denko,

Also I have used a font format in the cells(Albertus Medium)and inside the REPT" " use a thick bar like this █ from the Character Map and it turns out solid in length. Looks neat as well. Give it a try and see how it goes, but there's nothing wrong with what you are trying to achieve.


Les. ♪♫♪♫

 

[LesEwing]

I love my Avatar. Looks exactly like me. How did they do that ??


Les. ♪♫♪♫

 

[keymaster]

@LesEwing... you can actually set your avatar to whatever you want. Just go to gravatar.com and signup with your e-mail id (that you have used to register here). otherwise, this forum picks up a random emoticon avatar based on your e-mail id

 

[LesEwing]

@Chandoo ... I wouldn't change it ... I ♥ it. It is very similar to me when I can't get something right in Excel.


Great Site !

Cheers.♪♫♪♫

 

[richarta]

I tried to change mine, but cannot login to gravatar.

 

[keymaster]

@richarta see this.. http://chandoo.org/forums/topic/offftopic-avataricon

you need to register at gravatar first