This article explains how to set invert if negative in chart using XlsIO.
What is the purpose of invert if negative?
When a chart series contains both positive and negative data points, the data bars are created with same color by default. To make the chart more clear and professional, the color of negative data bars can be inverted by enabling Invert if Negative under format data series.
This can be achieved in XlsIO, using InvertIfNegative property of ChartSerieImpl class.
Invert if negative using XlsIO
Code snippet to set invert if negative
The following C#/ VB.NET complete code snippet shows how to set invert if negative in chart using XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|