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
-
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 Design 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.
-