Sparklines in Excel

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

    • First, select that data
    • Under the Insert tab, in the Sparklines group, choose either Line, Column, or Win/Loss
    • 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.
    • Click ok.

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

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!