Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SparkPoints Object (Excel)
Collapse the table of content
Expand the table of content

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.

© 2015 Microsoft