Spark lines and spark bars — miniature within-cell bar charts available in Excel 2010 and higher — are one of my favorite features of Excel. I use them to explore the patterns in my dataset, to see the highs and lows in my table, to think about what kinds of additional analyses I might want to conduct, and to get ideas for more formal charts that could be shared with my colleagues or clients in a report or presentation.
Comments