Excel and Lotus Notes in-Cell graphs

From a post at Lifehacker from a post at juiceanalytics showed a cool way to put mini graphs in a cell next to the data in Excel. This is not new but a good reminder of what can be done with old fashion ASCII art.

Reminds me to go back and look at the work of Edward Tufte and his beautiful displays of information - I have used sparklines and other techniques from his books.

Also worth pointing out that this also works nicely in lotus notes and domino views using basically the same code and exactly the same technique.

Graph in a view

The formulas in Notes for the above cols are:

@Repeat(ā€lā€;NumberField) for a Number Field
and
@Repeat(ā€lā€;@TextToNumber(TextField)) if a text Field

then you can format the col as you need