- Place the cell selector on the cell(s) to display the Sparkline.
- On the Insert (Charts on the Mac) ribbon, Sparklines (Insert Sparklines on the Mac) group, select the type of trend to display.
- Enter the range of data to be included.
- The Location Range should be the cell you selected in step #1.
- Click OK
Tuesday, March 1, 2011
Microsoft Excel: Sparklines
Available in both 2010 for Windows and 2011 for Mac, Sparklines can be a nifty little option. If you love the dynamic line charts for your data, but wished it was available to put at the end of a row/column right next to your data, you’re in luck. Sparklines are for you.