Create Sparkline Charts
Sparklines are small charts that fit inside individual cells in a sheet. Because of their condensed size, sparklines can reveal patterns in large data sets in a concise and highly visual way. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. A Sparkline has the greatest effect when it's positioned near the data that it represents. To create sparklines, you must select the data range that you want to analyze, and then select where you want to put the sparklines.
Insert Sparklines
1. Select the cell where you want to insert sparklines
2. From the Ribbon, click Charts tab go to Insert Sparklines, click the kind of sparklines that you want such as: Line, Column or Win/Loss
3. In the Insert Sparklines dialog box, select the data range for the sparkline and then click OK
4. Excel creates a Sparkline chart on the worksheet
TIP When you change the data on the sheet, sparklines update automatically
Format Sparklines
1. Click the cell that contains the sparkline
2. From the Ribbon, click Sparklines tab and use tools under commands groups to format the selected sparkline
