Small Excel Chart Inside the Cell
December 8th, 2009
Here is one tip for improving the readability of larger data tables – use in-cell graphics. This is based on using ordinary characters as graphic elements. It is possible to repeat the characters using Excel REPT() function.
Below is a statistical table from Eurostat that is tuned with in-cell graphics.
Tip 1: You can apply calculations to second parameter to fit the result into desired space (in this case, the numerical value is divided by 10)
Tip 2: Try experimenting with different characters for the repetition, like “-”, “o” as the first parameter for the function. You can also apply some other character at the end of the formula with “&”+[end character]
Tip 3: Changing fonts and font sizes of the cell can result in creative outcomes
Excel in-cell graphics for improved readability
Cool tip, thanks!