Excel for snucongo.org 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel Starter 2010 More...Less

A sparkline is a tiny chart in a worksheet cabinet that gives a visual representation of data. Usage sparklines to display trends in a series of values, such as seasonal increases or decreases, financial cycles, or to to mark maximum and also minimum values. Position a sparkline near its data for best impact.

You are watching: Tiny charts that fit within a cell and give a visual trend summary


Add a Sparkline

Select a empty cell at the finish of a heat of data.

Select Insert and choose Sparkline type, like Line, or Column.

Select cells in the row and also OK in menu.

More rows of data? Drag take care of to include a Sparkline because that each row.

Format a Sparkline chart

Select the Sparkline chart.

Select Sparkline and then choose an option.

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

Check Markers to to mark individual worths in the Sparkline chart.

Select a Style for the Sparkline.

Select Sparkline color and the color.

Select Sparkline shade > Weight to select the broad of the Sparkline.

Select Marker color to change the color of the markers.

If the data has actually positive and negative values, pick Axis to display the axis.

See more: Here Comes That Rainy Day Feeling Again Song, Here Comes That Rainy Day Feeling Again

Need an ext help?

You can always ask an skilled in the Excel technology Community or obtain snucongo.org in the answers community.

See Also

Analyze fads in data making use of Sparklines

acquire snucongo.org graph templates


Need much more help?

Expand her skills
Explore Training
Get brand-new features first
Join snucongo.org Insiders

Was this details helpful?

Thank you! Any much more feedback? (The an ext you tell us the more we can help.) have the right to you help us improve? (The much more you tell us the an ext we have the right to help.)

What impacted your experience?

Resolved my issue
Clear instructions
Easy come follow
No jargon
Pictures helped
Didn't enhance my screen
Incorrect instructions
Too technical
Not sufficient information
Not sufficient pictures

Any additional feedback? (Optional)

Submit feedback

Thank you for her feedback!

What's new
snucongo.org Store
English (United States) © snucongo.org 2021