I had some data and I needed some visually appealing way to see which values are bigger and which are smaller. Here, is what the below mentioned code will finally generate:

excel text graph

excel text graph

You can easily do this using “REPT()” function in MS Excel. It basically repeats a certain string a given number of times. It takes the following parameters:
1. The string that you want to repeat
2. Number of times that you want to repeat.

So, since my data ranges from 0-100, I just used the following exact code:
=REPT("●●",A7/5)
This will repeat “●●” string “A7/5″ number of times. Cell A7 in the above example contains the value 98, so the above code will repeat 19 times. I chose to divide by 5 just because I found it was aesthetically pleasing. You can figure out different values and see for yourself what works best for you.