Syncfusion.XlsIO.Base
Example 


MinusRange Property (IChartErrorBars)

Gets or sets IRange object with negative error value for custom error bar.
Syntax
'Declaration
 
Property MinusRange As IRange
'Usage
 
Dim instance As IChartErrorBars
Dim value As IRange
 
instance.MinusRange = value
 
value = instance.MinusRange
IRange MinusRange {get; set;}
Example
The following code illustrates how to set the minus range for IChartErrorBars
using Syncfusion.XlsIO;
            
class Program
{
    static void Main(string[] args)
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet sheet = workbook.Worksheets[0];
            
            //Add data
            sheet.Range["A1"].Text = "Jan";
            sheet.Range["B1"].Text = "Feb";
            sheet.Range["C1"].Text = "Mar";
            sheet.Range["A2"].Value = "10";
            sheet.Range["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            sheet.Range["A3"].Value = "15";
            sheet.Range["B3"].Value = "25";
            sheet.Range["C3"].Value = "35";
            sheet.Range["D2"].Value = "4";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C3"];
            
            //Set chart type
            chart.ChartType = ExcelChartType.Column_Clustered;
            
            //Get chart serie
            IChartSerie serie = chart.Series[0];
            
            //Enabling the Y Error bars
            serie.HasErrorBarsY = true;
            
            //Get Y Error Bars 
            IChartErrorBars errorBars = serie.ErrorBarsY;
            
            //Set error amount to custom
            errorBars.Type = ExcelErrorBarType.Custom;
            
            //Set minus range
            errorBars.MinusRange = sheet["D2"];
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also