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.
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


Post a Comment
You must be logged in to post a comment.