SparkPoints.Lastpoint property (Excel)

Returns a SparkColor object that represents the color and visibility of the marker for the last point of data on a sparkline. Read-only.

Syntax

expression.Lastpoint

expression A variable that represents a SparkPoints object.

Return value

SparkColor

Remarks

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.

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.