Table of contents
TOC
Collapse the table of content
Expand the table of content

Series.InvertColorIndex Property (PowerPoint)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Returns or sets the fill color for negative data points in a series. Read/write.

Syntax

expression. InvertColorIndex

expression A variable that represents a Series object.

Return Value

Integer

Remarks

The InvertColorIndex property enables you to set the fill color for negative data points as a color index value from 0 to 56. Instead of using the InvertColorIndex property, you can use the InvertColor property, which enables you to set the color as a specific numeric, hexadecimal, octal, or RGB color value.

For the InvertColorIndex property to have an effect, the InvertIfNegative property of the Series object must also be set to True.

Example

The following code example sets the fill color of negative data points in the first series of chart 2 to magenta.

ActiveSheet.ChartObjects("Chart 2").Activate

ActiveChart.SeriesCollection(1).InvertIfNegative = True

ActiveChart.SeriesCollection(1).InvertColorIndex = 7

See also

Concepts

Series Object

© 2018 Microsoft