Question: How do I display the total sales amount by way of a chart? I don’t want to use the normal chart options given in Microsoft Excel. Is there an alternative to the normal chart options?
Answer: Yes, the REPT function
Why: Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string
Syntax
REPT(text,number_times)
- Text Required. The text you want to repeat
- Number_times Required. A positive number specifying the number of times to repeat text
Applies To: MS Excel 2003, 2007, 2010
1. The screen shot below will be used to illustrate this example
If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email enablement@alchemex.com and yours could be the next Tip of the Week.
Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations
