Sparklines in Excel 2013

Sparklines are tiny graphs that fit in a single cell. Excel 2013 offers a few varieties and options.

sparklines

1. First, select that data
2. Under the Insert tab, in the Sparklines group, choose either Line, Column, or Win/Loss
3. In the pop up window, confirm the correct data is in the Data Range. Then update the Location Range to choose where your sparklines should go. You can select cells that already contain data if you prefer.
4. Click ok.

There are options for changing color, weight, and the design of the sparkines in the contextual design tab. Just click on the sparklines to make the tab available.

For more office techniques see our MS Office Tips.