Insert and Customize Sparklines charts
Insert a Sparkline chart
-
Go to Insert tab > Sparklines group > select the desired Sparkline chart
-
In the Create Sparklines dialog box, do the following:
-
In the Data Range box, click
button to temporarily collapse the dialog box
-
Select the range of cells on the worksheet
-
Click
button to restore the dialog box to its normal size. -
Click OK
Customize a Sparkline chart
-
Select one or more Sparkline charts
-
Go to Sparkline Tools tab > click Design tab
-
Do any of the following:
-
To show all values, select the Markers check box
-
To show negative values, select the Negative Points check box
-
To show the highest or the lowest values, select the High Point or Low Point check box
-
To show the first or the last values, select the First Point or Last Point check box
-
To apply a predefined style, in the Style group, select a desired style
-
To apply specific formatting to a sparkline, click either Sparkline Color or Marker Color
