• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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


New Member
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:


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?


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/
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... 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
@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 !

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

you need to register at gravatar first