Ever wanted to see data visually in excel without going through the complex wizard? Juice analysis has posted one of the neatest hacks to get graphical representation of data.


The hack uses simple function REPT.

Microsoft Excel 12 has similar functionality and is super easy to use.

See Lightweight data exploration in Excel for more detail.

This gets even better look at More on Excel in-cell graphing has additional information on this hack. They even have a great excel sheet demonstrating all the hacks mentioned in this article.