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.

  1. Place the cell selector on the cell(s) to display the Sparkline.
  2. On the Insert (Charts on the Mac) ribbon, Sparklines (Insert Sparklines on the Mac) group, select the type of trend to display.
  3. Enter the range of data to be included.
  4. The Location Range should be the cell you selected in step #1.
  5. Click OK