Office
Sign in
Add and format charts

Add sparkline charts

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

Sparklines are mini-charts placed in single cells, to show visual data trends. You can quickly add and format a Sparkline chart in your worksheet.

Add a Sparkline

  1. Select a blank cell at the end of a row of data.

  2. Select Insert and pick Sparkline type, like Line, or Column.

  3. Select cells in the row and OK in menu.

  4. More rows of data? Drag handle to add a Sparkline for each row.

Format a Sparkline chart

  1. Select the Sparkline chart.

  2. Select Design and then select an option:
    Sparklines Tools

    • Select Line, Column, or Win/Loss to change the chart type.

    • Check Markers to highlight individual values in the Sparkline chart.

    • Select a Style for the Sparkline.

    • Select Sparkline Color and the color.

    • Select Sparkline Color > Weight to select the width of the Sparkline.

    • Select Marker Color to change the color of the markers.

    • If the data has positive and negative values, select Axis to show the axis.

Want more?

Discover more courses like this at LinkedIn Learning

Analyze trends in data using Sparklines

Use Sparklines to show data trends

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×