To customize how High and Low Points, First and Last Points, Markers and Negative Points are displayed, click on the Marker Color button in the Style Click on the marker you want to change, then choose a color from the fly-out menu.To see more styles, click the more button in the bottom right corner of the selection box. In the Style group of the Design tab, choose the style you want.Select the sparkline or sparkline group you wish to change.Note that the style options in the Style group are updated when you make changes in the Show group.Ĭustomize the Style or Format of Sparklines Markers: Adds a marker at every data point.Negative Points: Adds color-coded markers to negative values.
You can also change colors, apply styles from Office’s pre-loaded style gallery or apply a custom style that you have saved. Categories: Excel®, Sparklines Tags: sparklinesĪfter your sparklines have been created, Excel offers several tools for you to control which value points are shown, set options on the vertical axis, and define how empty values are displayed.
