Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChartInterior Interface : SwapColorsOnNegative Property

SwapColorsOnNegative Property (IChartInterior)

True if foreground and background colors are swapped when the data value is negative. otherwise False.
Syntax
'Declaration
 
Property SwapColorsOnNegative As Boolean
'Usage
 
Dim instance As IChartInterior
Dim value As Boolean
 
instance.SwapColorsOnNegative = value
 
value = instance.SwapColorsOnNegative
bool SwapColorsOnNegative {get; set;}
Remarks
The SwapColorsOnNegative property works on Binary Excel format only. To know more about charts refer this link.
Example
The following code illustrates the use of SwapColorsOnNegative property.
using Syncfusion.XlsIO;
using System.Drawing;
            
class Example
{
   static void Main()
   {
      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1"].Text = "Student ID";
        sheet.Range["B1"].Text = "Student Name";
        sheet.Range["C1"].Text = "Mark(Out of 100)";
        sheet.Range["A1:C1"].AutofitColumns();
        sheet.Range["A2"].Number = 1;
        sheet.Range["A3"].Number = 2;
        sheet.Range["A4"].Number = 3;
        sheet.Range["A5"].Number = 4;
        sheet.Range["A6"].Number = 5;
        sheet.Range["B2"].Text = "Andrew";
        sheet.Range["B3"].Text = "Marson";
        sheet.Range["B4"].Text = "Jack";
        sheet.Range["B5"].Text = "Sam";
        sheet.Range["B6"].Text = "Breto";
        sheet.Range["C2"].Number = 77;
        sheet.Range["C3"].Number = 45;
        sheet.Range["C4"].Number = -92;
        sheet.Range["C5"].Number = 39;
        sheet.Range["C6"].Number = -55;
        
        //Create a Chart
        IChartShape chart = sheet.Charts.Add();
        chart.LeftColumn = 5;
        chart.RightColumn = 11;
        chart.Name = "Student Sample Chart";
        chart.ChartType = ExcelChartType.Cone_Clustered_3D;
        chart.DataRange = sheet.Range["B2:C6"];
        chart.IsSeriesInRows = false;
        
        //True if foreground and background colors are swapped when the data value is negative
        chart.Series[0].SerieFormat.Interior.SwapColorsOnNegative = true;
        
        workbook.SaveAs("Charts.xls");
        workbook.Close();
      }
   }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also