an extremely simple technique for adding simple bar charts or sparkline-like diagrams within the cells of an Excel spreadsheet. the already built-in Excel REPT function repeats any text entry a certain number of times. for instance, REPT(”X”,10) results in “XXXXXXXXXX”. so the trick is to repeat specific characters, such as a single bar “|” to create data bars.
see also a similar implementation in the upcoming Excel 12 & an artistic take as Excel drawings.
[juiceanalytics.com & juiceaanalytics.com]