Excel.SparkPoints.Lastpoint.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
SparkPoints.Lastpoint property (Excel)	vbaxl10.chm873078	vbaxl10.chm873078	Excel.SparkPoints.Lastpoint	33ad7c29-1538-1825-b94a-55fd65d7610e	05/16/2019	medium

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.

[!includeSupport and feedback]