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:
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]
Suh-weet!
Yeah, and I usually avoid MS office like a plague. But this thing is neat.