Akshay Jain

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

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.

gandolf.jpg

Credit: Petersengraph

For all those who are preparing for Entrance Exams for pursuing Masters in Economics (M.Sc. Quantitative Economics) for ISI Delhi Or Kolkata can read a nice blog on the same. The author of that blog cleared the entrance of ISI,DSE,IGIDR,JNU. Here you go: ISI M.Sc. Quant Eco

If you face any problem / doubt in DSE,ISI,JNU,IGIDR,MBE entrances then you can comment here or on that blog.

Enjoy!