summary of the trends of that data. For example, if a row of data contained the sales for a given store during each month of the year, you could put a Sparkline at the end of that row to see what the overall trend was
throughout the year.
1. Navigate to the PivotTable worksheet.
2. Click in cell F5.
3. Click Insert | Sparklines | Line.
4. For the Data Range, type in B5:E231.
5. For the Location Range, type in F5:F231.
6. Click OK.
7. With a cell containing a Sparkline selected, click Sparkline Tools | Design | Style | Sparkline Color |
Orange, Accent 2, Darker 25%
