![]() The following example turns on the data label for the second point in series one on the chart sheet named Chart1, and sets the data label text to Saturday. Use the DataLabel property of the Point object to return the DataLabel object for a single point. ![]() SeriesCollection(1).DataLabels(5).NumberFormat = "0.000" ![]() The following example sets the number format for the fifth data label in series one in embedded chart one on worksheet one. Use DataLabels ( index), where index is the data-label index number, to return a single DataLabel object. For a series without definable points (such as an area series), the DataLabels collection contains a single DataLabel object. The DataLabels collection contains a DataLabel object for each point. In a series, the DataLabel object is a member of the DataLabels collection. Represents the data label on a chart point or trendline. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |