Series.InvertIfNegative property (Excel)
True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. Read/write Boolean.
expression A variable that represents a Series object.
This example inverts the pattern for negative values in series one in Chart1. The example should be run on a 2D column chart.
Charts("Chart1").SeriesCollection(1).InvertIfNegative = True
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.