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!
07.09.07 12:49 am
Nice trick. I like these types of shortcuts.
#107.09.07 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!
#225.02.08 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
#316.06.08 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.
#4