Excel 2010 Tips for Working with Sparklines
A few good tips for working with Excel 2010 Sparklines:
-
Sparklines are transparent. You can see through to the underlying cell, which means that the fill color of the underlying cell and the text in the underlying cell will both show through.
-
Make the font really small and align the text with the edge of the cell. Then this will make the text look like a title or a legend.
-
Turn on wrap text and make the cell tall enough for 5 or 10 lines of text in the cell. Then you can control the position of the text in the cell by using vbLf characters in VBA.
-
Sparklines work better when they are bigger than a typical cell.
-
Sparklines created together are grouped. Therefore, changes made to one sparkline are made to all sparklines.
-
Sparklines can be created on a separate worksheet than the data.
-
Sparklines look better when there is some white space around the cells. To do this manually would be difficult because you would have to create each sparkline one at a time. It is easy to do here because you can leverage VBA.