Thursday, July 26, 2007

OMFG! Excel kungfuporn!

via lifehacker, comes this SWEET little excel tip:

a clever little Excel trick that creates a bar graph inside cells using the repeat (REPT) function.

REPT looks like this:=REPT(text,number_of_times)For instance, REPT("X",10) gives you "XXXXXXXXXX". For in-cell bar charts, the trick is to repeat a single bar "". When formatted in 8 point Arial font, single bars look like bar graphs.

to get this:


In-excel music visualizer can't be far off!

No comments: