Class SparkPoints (Excel VBA)
The class SparkPoints represents the settings of the markers for points of data on a sparkline.
Firstpoint
Returns a SparkColor object that represents the color and visibility of the marker for the first point of data on a sparkline.
The Firstpoint property corresponds to the setting of the First Point check box in the Show section, and of the First Point item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.
Highpoint
Returns a SparkColor object that represents the color and visibility of the marker for the highest point of data on a sparkline.
The Highpoint property corresponds to the setting of the High Point check box in the Show section, and of the High Point item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.
Lastpoint
Returns a SparkColor object that represents the color and visibility of the marker for the last point of data on a sparkline.
The Lastpoint property corresponds to the setting of the Last Point check box in the Show section, and of the Last Point item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.
Lowpoint
Returns a SparkColor object that represents the color and visibility of the marker for the lowest point of data on a sparkline.
The Lowpoint property corresponds to the setting of the Low Point check box in the Show section, and of the Low Point item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.
Markers
Returns a SparkColor object that represents the color and visibility of markers for positive points of data on a sparkline.
The Markers property corresponds to the setting of the Markers check box in the Show section, and of the Markers item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.
Negative
Returns a SparkColor object that represents the color and visibility of markers for negative points of data on a sparkline.
The Negative property corresponds to the setting of the Negative Point check box in the Show section, and of the Negative Points item on the Marker Color drop-down list in the Style section of the Sparkline Tools Design tab of the ribbon.
Parent
Returns the parent SparklineGroup object for the specified object. Read-only.