September 5 th

4

Cool little excel trick for showing simple bar graphs

Posted by Andy Bailey
1,106 views

Excel Simple BarHere’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!

Popularity: 2% [?]

Category : Business Software

Related Posts

  • Excel tip: How to not show zero values for forumla result
  • Rainy day - perfect weather for code tinkerers
  • How to extract names and email addresses from your WP database
  • Why don’t they understand?
  • New top 3 scoreboard for Aqua Game
  • Hello Stumbler - Wordpress plugin for Stumbleupon visitors
  • A mybloglogdogg - against TOS?

    • Comments

    CHESSNOID (13 comments.) September 7, 2007

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

    Andy Bailey September 7, 2007

    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!

    Lynne Kempton (3 comments.) February 25, 2008

    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

    video conferencing (1 comments.) June 16, 2008

    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.

    Leave a comment

    13 online now
    the most online was 176
    elottery Ajax commentluv
    Sponsors
    available ad space available ad space available ad space available ad space available ad space available ad space