title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
Series.InvertIfNegative property (Excel) |
vbaxl10.chm578092 |
|
|
06c963ac-6e81-5f45-b8b9-8c61bf0c02b6 |
05/11/2019 |
medium |
True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. Read/write Boolean.
expression.InvertIfNegative
expression A variable that represents a Series object.
This example inverts the pattern for negative values in series one on Chart1. The example should be run on a 2D column chart.
Charts("Chart1").SeriesCollection(1).InvertIfNegative = True
[!includeSupport and feedback]