Excel for invernessgangshow.net 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel Starter 2010 More...Less

A sparkline is a small chart in a worksheet cell that offers a visual depiction of data. Usage sparklines to present trends in a collection of values, such together seasonal rises or decreases, economic cycles, or to to mark maximum and also minimum values. Position a sparkline near its data for greatest impact.

You are watching: Excel includes four types of sparkline charts: line, column, win/loss, and stock.


Add a Sparkline

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

Select Insert and pick Sparkline type, favor Line, or Column.

Select cells in the row and also OK in menu.

More rows the data? Drag manage to include 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 readjust the graph type.

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

Select a Style for the Sparkline.

Select Sparkline shade and the color.

Select Sparkline color > Weight to select the width of the Sparkline.

Select Marker color to change the shade of the markers.

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

See more: How Much Is 400 Kg In Pounds, Convert 400 Kilograms To Pounds

Need an ext help?

You can always ask an expert in the Excel technology Community or acquire invernessgangshow.net in the answers community.

See Also

Analyze patterns in data using Sparklines

gain invernessgangshow.net chart templates


Need more help?

Expand her skills
Explore Training
Get brand-new features first
Join invernessgangshow.net Insiders

Was this info helpful?

Thank you! Any more feedback? (The an ext you tell united state the much more we can help.)Can you aid us improve? (The an ext you tell united state the much more we have the right to help.)
What affected your experience?
Resolved my issue
Clear instructions
Easy come follow
No jargon
Pictures helped
Didn't enhance my screen
Incorrect instructions
Too technical
Not enough information
Not enough pictures
Any added feedback? (Optional)
Submit feedback

Thank you for your feedback!

What's new
invernessgangshow.net Store
English (United States) © invernessgangshow.net 2021