Index Property

  • Article

Returns the index number of the specified object within the collection of similar objects. Read/write Long for the ChSeries object; read-only Long for all other objects in the Applies To list.

expression**.Index**

*expression   * Required. An expression that returns one of the objects in the Applies To list.

Remarks

You can set the index number of a ChSeries object. The specified series is moved to the specified position, and other series are reordered as necessary.

The index value of a ListRow object corresponds to its current position in the XML list. Following a sort, or after adding or deleting a row, a given row may have a new index value based on its new position.

Example

This example moves series 1 to the fourth index position of an XY chart containing 6 series. During the move, series 2 through 4 are reordered to series 1 through 3. Series 0 and series 5 stay in the same position.

ChartSpace1.Charts(0).SeriesCollection(1).Index = 4

Applies to | ChAxis Object | ChCategoryLabel Object | ChChart Object | ChDataLabel Object | ChDataLabels Object | ChDropZone Object | ChErrorBars Object | ChLegendEntry Object | ChPoint Object | ChSeries Object | ChTrendline Object | Heading Object | ListRow Object | Name Object | Pane Object | Window Object | Worksheet Object