logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
November 2019 update
December 13, 2019
HOW TO DELETE ALTERNATE ROW
April 19, 2021

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.

1

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

1. Repeat function
2. & function

Step 1: Input the name of stocks with their prices

2

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.

3. Step 2

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.

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

5. Step 4

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.
WhatsApp Image 2021-04-16 at 17.04.03
Share
1

Related posts

December 16, 2021

Stacking in EXCEL


Read more
December 9, 2021

SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW


Read more
November 25, 2021

Circular Referencing Solution


Read more

Comments are closed.

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'