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!