Excel in-cell Bar Charts

Ever wanted to create in-cell bar chars to help you visualize some large data set? A picture is worth a thousand words, so I will just show you what I am talking about and how to do it:

Excel in-cell Bar Chart
image © juiceanalytics

I never really thought that you could use the REPT formula in order to do this. But this is ingenious! Juice Analytics explains this in detail, and also provides some tips on how to create even fancier, and complicated in-cell charts.

Related Posts:

  • Excel: Too many different cell formats
  • Parsing Excel Files with Perl
  • Dump MySQL table into CSV file
  • Excel: Adding Checkboxes the Easy Way
  • What kind of applications do you have open right now?
  • Read Excel with PHP
  • You know you are working at a small company if…
  • Convert a large Access table into Excel files
  • Gmail open to public? Google collecting cell phone numbers!
  • MS Office Addiction

  • 2 Responses to “Excel in-cell Bar Charts”

    1. Gravatar Ara Pehlivanian CANADA Says: Reply to this comment

      Suh-weet!

      Posted using Mozilla Firefox Mozilla Firefox 1.5.0.5 on Windows Windows XP
    2. Gravatar Luke UNITED STATES Says: Reply to this comment

      Yeah, and I usually avoid MS office like a plague. But this thing is neat.

      Posted using Mozilla Firefox Mozilla Firefox 1.5.0.6 on Windows Windows XP

    Leave a Reply

    XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <pre lang=""> <em> <i> <strike> <strong>

    [Quote selected]