SparkPoints Object (Excel)

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

Version Information

Version Added: Excel 2010

Remarks

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.

See Also

Concepts

SparkPoints Object Members

Excel Object Model Reference