A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Position a sparkline near its data for greatest impact.
![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://cxcs.microsoft.net/static/public/surface-and-devices/neutral/4873755a-8b1e-497e-bc54-101d1e75d3e7/d07c07fd6aabfe12ed716e87301dc3a1a3a7b5b0.png)
Add a Sparkline
-
Select a blank cell at the end of a row of data.
-
Select Insert and pick Sparkline type, like Line, or Column.
-
Select cells in the row and OK in menu.
-
More rows of data? Drag handle to add a Sparkline for each row.
Format a Sparkline chart
-
Select the Sparkline chart.
-
Select Sparkline and then select an option.
-
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.
-
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.