Repeat Function

April 19, 2021

In-cell, charts can be made using the REPEAT function. The syntax is REPT(text,number_times). In “text” you need to select the text which is to be repeated and in “number times” –the number of times the text is to be repeated is entered. The “&” function is used to join the text. To plot Stock prices in the cells with their prices mentioned in the above cell, by using the REPEAT function.

Here’s how to use REPEAT and “&” function

Step 1: Input the name of stocks with their prices

Step 2: First, make “Dot chart” by using REPEAT and “&” function

Put " " as text in the formula and repeat it according to the price in the cell (Example: 248 for ITC), and join "•" with “&” function, but since in the case of ITC, the position of the "•" is to be at 248th position, subtract the number of repetitions by 1.
The width of the cell will increase extensively, in order to make the chart shorter divide the number of repetitions by 10.

Step 3: Now plot the stock price above the dot.
To make the stock price aligned to the center of the "•" subtract the number of repetitions by 3.

Step 4: The width of the cell is determined by the stock having the highest value (BPCL) because it will have the maximum number of spaces. In order to fix the width of the same, set an upper boundary rounded up to the nearest hundred (for example 600 in this case).

Contributor:Ankit Agarwal.

Freelancer at Upwork, Ex Junior Associate at Leveraged Growth. I work on MS Excel MS Word Projects to fulfill client's requirements. I have a keen interest in Automation, Visualization, Analysis of different data and continuously trying to learn and improve on it. Also, I'm pursuing CFA and have a bachelor's degree in Accounts and Finance.