Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to use the REPT Function to represent data graphically
Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

One neat trick that I recently discovered in Excel is how to represent data graphically using the REPT Function and a symbol font. What the REPT Function does is that it will repeat a specified character a given amount of times. Below, we will use an example to demonstrate how this is done.

How to use the REPT Function to repeat a certain character:

  1. Enter your data as shown in the image or use your own data.
  2. Select Cell B1 and type the following formula: =REPT(”n”,A1).
  3. Use the fill handle to copy the formula as needed.
  4. Change the font of the text in Column B to the Wingdings symbol font so that it will have the appearance of what we have in our example.

How to use the REPT Function to represent data graphically

You should now be set! This tip is compatible in Excel 97, 2000, 2003 and 2007.

How to use the REPT Function to represent data graphically
  1. How to Utilize Data Entry Rules to Validate data in Excel 2007
  2. How to Use the COUNTA function to count cells containing data
  3. Use the COUNT function to count cells containing numeric data
  4. How to work with VBA Data Types and syntax in Excel
  5. How to Make Excel Read Back Your Data in Excel 2007

Article Information

Category
Formula and Function Examples

Tags
, , ,

Trackback URI

Comments RSS


Leave a Reply

← Using the SUM function to Sum a Range of Values in Excel
How to Use the EDATE function to calculate months in Excel →