SparkPoints object (Excel)

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

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 to the settings of the items on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.

Properties

• Application
• Creator
• Firstpoint
• Highpoint
• Lastpoint
• Lowpoint
• Markers
• Negative
• Parent

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.