Here’s a cool little thing to represent values as a simple bar graph without having to go to the trouble of using Excel’s graph function, it really helps to give you a good quick reference on the values.
It’s simply a case of using the formula command “=REPT(“|”,F4)”.
=REPT is the command, the next option is what to display and next is the cell that you wish to represent. All REPT does is REPEAT a given character as many times as the value of the cell specified.
Very useful!
September 7th, 2007 on 12:49 am
Nice trick. I like these types of shortcuts.
September 7th, 2007 on 10:40 am
I thought it was pretty neat too!
there’s a few other things I use with Excel, I’ll get around to getting them on here one day..
thanks for visiting!
February 25th, 2008 on 3:03 pm
This is a really clever idea. I might even do a short excel video tutorial of it at http://www.learntouse.org and link back to you with it.
Lynne Kempton’s last blog post..Absolute & Relative Cell References
June 16th, 2008 on 11:32 am
Lynne Kempton i checked your link i never got any help from there can u tell me that how to learn more ????
video conferencings last blog post..PCS-TL30 :: 17inch Desktop Video Communication System by SONY Video conferencing.