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).