< img src="https://support.content.office.net/en-us/media/4873755a-8b1e-497e-bc54-101d1e75d3e7.png" > A sparkline is a small chart in a worksheet cell that provides a graph of information. Use sparklines to show patterns in a series of values, such as seasonal boosts or reductions, economic cycles, or to highlight optimum and minimum worths. Position a sparkline near its data for greatest impact.
Include a Sparkline Select a blank cell at the
end of a row of information. Select Insert and select Sparkline type, like Line, or Column.
Select cells in the row and OKAY in menu.
More rows of data? Drag manage to include a Sparkline for each row.
Format a Sparkline chart
-
Select the Sparkline chart.
-
Select Sparkline and then choose an option.
-
Select Line, Column, or Win/Loss to alter the chart type.
-
Examine 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 choose the width of the Sparkline.
-
Select Marker Color to alter the color of the markers.
-
If the information has positive and negative values, choose Axis to show the axis.
-
Required more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.
See Likewise
Examine patterns in data using Sparklines
Get Microsoft chart templates
Want to utilize sparklines in Excel? Learn how to utilize sparklines to show data trends and visually represent your information within a cell of an Excel worksheet.
