Group items tagged

Excel Excel tip: Instant in-cell graphs The Juice Analytics blog has 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.