You can create an in cell bar chart with the text function REPT! (True or False?)
Hint: Try the following:
Put the numbers 100, 20, 80, 50 in cells A1 to A4. In cell B1 enter the formula: =Rept("o",Int(A1/5)) and copy it down. Try changing the font type to Wingdings. Play around with the numbers and see what happens. You could also try =rept(" ",int(A1/5))&"o".
True | |
False |
True. Cell bar chart can be created using Rept function.
Show formula
Get Answers For Free
Most questions answered within 1 hours.