Excel: Instant in-cell graphs

Use the repeat (REPT) function in Excel to create a bar graph inside cells. 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. Of course, number_of_times can also be substituted with a cell number.