Cool little excel trick for showing simple bar graphs

Posted on September 5, 2007 by Andy Comments Off

Excel Simple Bar

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!

About Andy

This is my personal website where I (occasionally) post about things going on in the world of me. I am the creator of CommentLuv and administrator of comluv.com
Business Software

0 responses to Cool little excel trick for showing simple bar graphs

  1. CHESSNOID
    September 7, 2007 at 12:49 am

    Nice trick. I like these types of shortcuts. ;)

  2. Andy Bailey
    September 7, 2007 at 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!

  3. Lynne Kempton
    February 25, 2008 at 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

  4. video conferencing
    June 16, 2008 at 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.