SparkPoints Object (Excel)
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

SparkPoints Object (Excel)

Represents the settings of the markers for points of data on a sparkline.

Version Added: Excel 2010

Use the SparkPoints object to set the color and visibility of markers for points of data on a sparkline. Use the Points property of the SparklineGroup object to return a SparkPoints object. The properties of the SparkPoints object correspond to the settings of the High Point, Low Point, Negative Point, First Point, Last Point, and Markers check boxes in the Show section, and of the items on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.

© 2016 Microsoft