Cool little excel trick for showing simple bar graphs

September
5

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!

Business Software


0 Comments zu “Cool little excel trick for showing simple bar graphs”

  1. CHESSNOID
    07.09.07 12:49 am

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

    #1

  2. Andy Bailey
    07.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!

    #2

  3. Lynne Kempton
    25.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

    #3

  4. video conferencing
    16.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