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.