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.

[tags]excel, in-cell charts, bar chart, rept[/tags]

This entry was posted in technology. Bookmark the permalink.



2 Responses to Excel in-cell Bar Charts

  1. Luke UNITED STATES Mozilla Firefox Windows says:

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

    Reply  |  Quote

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>