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:
Post a Comment