menu

Xamarin.Forms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface IOfficeChartErrorBars - Xamarin.Forms API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface IOfficeChartErrorBars

    Represents the error bars on a chart series.

    Namespace: Syncfusion.OfficeChart
    Assembly: Syncfusion.OfficeChart.Portable.dll
    Syntax
    public interface IOfficeChartErrorBars

    Properties

    Border

    Gets the border object of the error bars. Read-only.

    Declaration
    IOfficeChartBorder Border { get; }
    Property Value
    Type
    IOfficeChartBorder
    Examples
    IPresentation presentation = Presentation.Create();
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 500, 300);
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Create a new chart series with the name
    IOfficeChartSerie serieMarch = chart.Series.Add("March");
    //Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData[2, 4, 4, 4];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Enable error bar X for a serie
    chart.Series[0].HasErrorBarsX = true;
    //Get the error bar X
    IOfficeChartErrorBars errorBars = chart.Series[0].ErrorBarsX;
    //set the border line color
    errorBars.Border.LineColor = System.Drawing.Color.BlueViolet;
    //Set the border line weight
    errorBars.Border.LineWeight = OfficeChartLineWeight.Wide;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();
    Dim presentation__1 As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentation__1.Slides.Add(SlideLayoutType.Blank)
    'Add chart to the slide with position and size
    Dim chart As IPresentationChart = slide.Charts.AddChart(100, 10, 500, 300)
    'Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan")
    chart.ChartData.SetValue(1, 3, "Feb")
    chart.ChartData.SetValue(1, 4, "March")
    'Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011")
    chart.ChartData.SetValue(2, 2, "60")
    chart.ChartData.SetValue(2, 3, "70")
    chart.ChartData.SetValue(2, 4, "80")
    'Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009")
    chart.ChartData.SetValue(3, 2, "80")
    chart.ChartData.SetValue(3, 3, "70")
    chart.ChartData.SetValue(3, 4, "60")
    'Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010")
    chart.ChartData.SetValue(4, 2, "60")
    chart.ChartData.SetValue(4, 3, "70")
    chart.ChartData.SetValue(4, 4, "80")
    'Create a new chart series with the name
    Dim serieJan As IOfficeChartSerie = chart.Series.Add("Jan")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData(2, 2, 4, 2)
    'Create a new chart series with the name
    Dim serieFeb As IOfficeChartSerie = chart.Series.Add("Feb")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData(2, 3, 4, 3)
    'Create a new chart series with the name
    Dim serieMarch As IOfficeChartSerie = chart.Series.Add("March")
    'Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData(2, 4, 4, 4)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Enable error bar X for a serie
    chart.Series(0).HasErrorBarsX = True
    'Get the error bar X
    Dim errorBars As IOfficeChartErrorBars = chart.Series(0).ErrorBarsX
    'set the border line color
    errorBars.Border.LineColor = System.Drawing.Color.BlueViolet
    'Set the border line weight
    errorBars.Border.LineWeight = OfficeChartLineWeight.Wide
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    Chart3DOptions

    Gets the 3-D�effect formatting properties for the error bars. Read-only

    Declaration
    IThreeDFormat Chart3DOptions { get; }
    Property Value
    Type Description
    IThreeDFormat

    The chart3 D options.

    HasCap

    Gets or sets the value that indicates error bars has cap or not.

    Declaration
    bool HasCap { get; set; }
    Property Value
    Type
    System.Boolean
    Examples
    IPresentation presentation = Presentation.Create();
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 500, 300);
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Create a new chart series with the name
    IOfficeChartSerie serieMarch = chart.Series.Add("March");
    //Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData[2, 4, 4, 4];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Enable error bar X for a serie
    chart.Series[0].HasErrorBarsX = true;
    //Get the error bar X
    IOfficeChartErrorBars errorBars = chart.Series[0].ErrorBarsX;
    //Set the type
    errorBars.Type = OfficeErrorBarType.StandardDeviation;
    //Set the cap for errorbars
    errorBars.HasCap = true;
    //Set the include property
    errorBars.Include = OfficeErrorBarInclude.Minus;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();
    Dim presentation__1 As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentation__1.Slides.Add(SlideLayoutType.Blank)
    'Add chart to the slide with position and size
    Dim chart As IPresentationChart = slide.Charts.AddChart(100, 10, 500, 300)
    'Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan")
    chart.ChartData.SetValue(1, 3, "Feb")
    chart.ChartData.SetValue(1, 4, "March")
    'Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011")
    chart.ChartData.SetValue(2, 2, "60")
    chart.ChartData.SetValue(2, 3, "70")
    chart.ChartData.SetValue(2, 4, "80")
    'Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009")
    chart.ChartData.SetValue(3, 2, "80")
    chart.ChartData.SetValue(3, 3, "70")
    chart.ChartData.SetValue(3, 4, "60")
    'Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010")
    chart.ChartData.SetValue(4, 2, "60")
    chart.ChartData.SetValue(4, 3, "70")
    chart.ChartData.SetValue(4, 4, "80")
    'Create a new chart series with the name
    Dim serieJan As IOfficeChartSerie = chart.Series.Add("Jan")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData(2, 2, 4, 2)
    'Create a new chart series with the name
    Dim serieFeb As IOfficeChartSerie = chart.Series.Add("Feb")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData(2, 3, 4, 3)
    'Create a new chart series with the name
    Dim serieMarch As IOfficeChartSerie = chart.Series.Add("March")
    'Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData(2, 4, 4, 4)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Enable error bar X for a serie
    chart.Series(0).HasErrorBarsX = True
    'Get the error bar X
    Dim errorBars As IOfficeChartErrorBars = chart.Series(0).ErrorBarsX
    'Set the type
    errorBars.Type = OfficeErrorBarType.StandardDeviation
    'Set the cap for errorbars
    errorBars.HasCap = True
    'Set the include property
    errorBars.Include = OfficeErrorBarInclude.Minus
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    Include

    Gets or sets error bar include type.

    Declaration
    OfficeErrorBarInclude Include { get; set; }
    Property Value
    Type
    OfficeErrorBarInclude
    Examples
    IPresentation presentation = Presentation.Create();
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 500, 300);
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Create a new chart series with the name
    IOfficeChartSerie serieMarch = chart.Series.Add("March");
    //Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData[2, 4, 4, 4];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Enable error bar X for a serie
    chart.Series[0].HasErrorBarsX = true;
    //Get the error bar X
    IOfficeChartErrorBars errorBars = chart.Series[0].ErrorBarsX;
    //Set the type
    errorBars.Type = OfficeErrorBarType.StandardDeviation;
    //Set the cap for errorbars
    errorBars.HasCap = true;
    //Set the include property
    errorBars.Include = OfficeErrorBarInclude.Minus;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();
    Dim presentation__1 As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentation__1.Slides.Add(SlideLayoutType.Blank)
    'Add chart to the slide with position and size
    Dim chart As IPresentationChart = slide.Charts.AddChart(100, 10, 500, 300)
    'Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan")
    chart.ChartData.SetValue(1, 3, "Feb")
    chart.ChartData.SetValue(1, 4, "March")
    'Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011")
    chart.ChartData.SetValue(2, 2, "60")
    chart.ChartData.SetValue(2, 3, "70")
    chart.ChartData.SetValue(2, 4, "80")
    'Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009")
    chart.ChartData.SetValue(3, 2, "80")
    chart.ChartData.SetValue(3, 3, "70")
    chart.ChartData.SetValue(3, 4, "60")
    'Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010")
    chart.ChartData.SetValue(4, 2, "60")
    chart.ChartData.SetValue(4, 3, "70")
    chart.ChartData.SetValue(4, 4, "80")
    'Create a new chart series with the name
    Dim serieJan As IOfficeChartSerie = chart.Series.Add("Jan")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData(2, 2, 4, 2)
    'Create a new chart series with the name
    Dim serieFeb As IOfficeChartSerie = chart.Series.Add("Feb")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData(2, 3, 4, 3)
    'Create a new chart series with the name
    Dim serieMarch As IOfficeChartSerie = chart.Series.Add("March")
    'Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData(2, 4, 4, 4)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Enable error bar X for a serie
    chart.Series(0).HasErrorBarsX = True
    'Get the error bar X
    Dim errorBars As IOfficeChartErrorBars = chart.Series(0).ErrorBarsX
    'Set the type
    errorBars.Type = OfficeErrorBarType.StandardDeviation
    'Set the cap for errorbars
    errorBars.HasCap = True
    'Set the include property
    errorBars.Include = OfficeErrorBarInclude.Minus
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    MinusRange

    Gets or sets custom minus value.

    Declaration
    IOfficeDataRange MinusRange { get; set; }
    Property Value
    Type
    IOfficeDataRange

    NumberValue

    Gets or sets number value.

    Declaration
    double NumberValue { get; set; }
    Property Value
    Type
    System.Double
    Examples
    IPresentation presentation = Presentation.Create();
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 500, 300);
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Create a new chart series with the name
    IOfficeChartSerie serieMarch = chart.Series.Add("March");
    //Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData[2, 4, 4, 4];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Enable error bar X for a serie
    chart.Series[0].HasErrorBarsX = true;
    //Get the error bar X
    IOfficeChartErrorBars errorBars = chart.Series[0].ErrorBarsX;
    //Set the include property
    errorBars.Include = OfficeErrorBarInclude.Minus;  
    //Set the number value
    errorBars.NumberValue = 12.78;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();
    Dim presentation__1 As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentation__1.Slides.Add(SlideLayoutType.Blank)
    'Add chart to the slide with position and size
    Dim chart As IPresentationChart = slide.Charts.AddChart(100, 10, 500, 300)
    'Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan")
    chart.ChartData.SetValue(1, 3, "Feb")
    chart.ChartData.SetValue(1, 4, "March")
    'Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011")
    chart.ChartData.SetValue(2, 2, "60")
    chart.ChartData.SetValue(2, 3, "70")
    chart.ChartData.SetValue(2, 4, "80")
    'Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009")
    chart.ChartData.SetValue(3, 2, "80")
    chart.ChartData.SetValue(3, 3, "70")
    chart.ChartData.SetValue(3, 4, "60")
    'Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010")
    chart.ChartData.SetValue(4, 2, "60")
    chart.ChartData.SetValue(4, 3, "70")
    chart.ChartData.SetValue(4, 4, "80")
    'Create a new chart series with the name
    Dim serieJan As IOfficeChartSerie = chart.Series.Add("Jan")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData(2, 2, 4, 2)
    'Create a new chart series with the name
    Dim serieFeb As IOfficeChartSerie = chart.Series.Add("Feb")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData(2, 3, 4, 3)
    'Create a new chart series with the name
    Dim serieMarch As IOfficeChartSerie = chart.Series.Add("March")
    'Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData(2, 4, 4, 4)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Enable error bar X for a serie
    chart.Series(0).HasErrorBarsX = True
    'Get the error bar X
    Dim errorBars As IOfficeChartErrorBars = chart.Series(0).ErrorBarsX
    'Set the include property
    errorBars.Include = OfficeErrorBarInclude.Minus
    'Set the number value
    errorBars.NumberValue = 12.78
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    PlusRange

    Gets or sets custom plus value.

    Declaration
    IOfficeDataRange PlusRange { get; set; }
    Property Value
    Type
    IOfficeDataRange

    Shadow

    Gets shadow formatting properties for the error bars.

    Declaration
    IShadow Shadow { get; }
    Property Value
    Type Description
    IShadow

    The shadow.

    Examples
    IPresentation presentation = Presentation.Create();
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 500, 300);
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Create a new chart series with the name
    IOfficeChartSerie serieMarch = chart.Series.Add("March");
    //Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData[2, 4, 4, 4];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Enable error bar X for a serie
    chart.Series[0].HasErrorBarsX = true;
    //Get the error bar X
    IOfficeChartErrorBars errorBars = chart.Series[0].ErrorBarsX;
    //Set the shadow color
    errorBars.Shadow.ShadowColor = System.Drawing.Color.Brown;
    //Set the inner preset of shadow
    errorBars.Shadow.ShadowInnerPresets = Office2007ChartPresetsInner.InsideDiagonalBottomRight;
    //Set the size of the shadow
    errorBars.Shadow.Size = 34;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();
    Dim presentation__1 As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentation__1.Slides.Add(SlideLayoutType.Blank)
    'Add chart to the slide with position and size
    Dim chart As IPresentationChart = slide.Charts.AddChart(100, 10, 500, 300)
    'Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan")
    chart.ChartData.SetValue(1, 3, "Feb")
    chart.ChartData.SetValue(1, 4, "March")
    'Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011")
    chart.ChartData.SetValue(2, 2, "60")
    chart.ChartData.SetValue(2, 3, "70")
    chart.ChartData.SetValue(2, 4, "80")
    'Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009")
    chart.ChartData.SetValue(3, 2, "80")
    chart.ChartData.SetValue(3, 3, "70")
    chart.ChartData.SetValue(3, 4, "60")
    'Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010")
    chart.ChartData.SetValue(4, 2, "60")
    chart.ChartData.SetValue(4, 3, "70")
    chart.ChartData.SetValue(4, 4, "80")
    'Create a new chart series with the name
    Dim serieJan As IOfficeChartSerie = chart.Series.Add("Jan")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData(2, 2, 4, 2)
    'Create a new chart series with the name
    Dim serieFeb As IOfficeChartSerie = chart.Series.Add("Feb")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData(2, 3, 4, 3)
    'Create a new chart series with the name
    Dim serieMarch As IOfficeChartSerie = chart.Series.Add("March")
    'Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData(2, 4, 4, 4)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Enable error bar X for a serie
    chart.Series(0).HasErrorBarsX = True
    'Get the error bar X
    Dim errorBars As IOfficeChartErrorBars = chart.Series(0).ErrorBarsX
    'Set the shadow color
    errorBars.Shadow.ShadowColor = System.Drawing.Color.Brown
    'Set the inner preset of shadow
    errorBars.Shadow.ShadowInnerPresets = Office2007ChartPresetsInner.InsideDiagonalBottomRight
    'Set the size of the shadow
    errorBars.Shadow.Size = 34
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    Type

    Gets or sets chart error bar type.

    Declaration
    OfficeErrorBarType Type { get; set; }
    Property Value
    Type
    OfficeErrorBarType
    Examples
    IPresentation presentation = Presentation.Create();
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 500, 300);
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Create a new chart series with the name
    IOfficeChartSerie serieMarch = chart.Series.Add("March");
    //Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData[2, 4, 4, 4];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Enable error bar X for a serie
    chart.Series[0].HasErrorBarsX = true;
    //Get the error bar X
    IOfficeChartErrorBars errorBars = chart.Series[0].ErrorBarsX;
    //set the border line color
    errorBars.Border.LineColor = System.Drawing.Color.BlueViolet;
    //Set the border line weight
    errorBars.Border.LineWeight = OfficeChartLineWeight.Wide;
    //Set the type
    errorBars.Type = OfficeErrorBarType.StandardDeviation;
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();
    Dim presentation__1 As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentation__1.Slides.Add(SlideLayoutType.Blank)
    'Add chart to the slide with position and size
    Dim chart As IPresentationChart = slide.Charts.AddChart(100, 10, 500, 300)
    'Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan")
    chart.ChartData.SetValue(1, 3, "Feb")
    chart.ChartData.SetValue(1, 4, "March")
    'Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011")
    chart.ChartData.SetValue(2, 2, "60")
    chart.ChartData.SetValue(2, 3, "70")
    chart.ChartData.SetValue(2, 4, "80")
    'Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009")
    chart.ChartData.SetValue(3, 2, "80")
    chart.ChartData.SetValue(3, 3, "70")
    chart.ChartData.SetValue(3, 4, "60")
    'Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010")
    chart.ChartData.SetValue(4, 2, "60")
    chart.ChartData.SetValue(4, 3, "70")
    chart.ChartData.SetValue(4, 4, "80")
    'Create a new chart series with the name
    Dim serieJan As IOfficeChartSerie = chart.Series.Add("Jan")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData(2, 2, 4, 2)
    'Create a new chart series with the name
    Dim serieFeb As IOfficeChartSerie = chart.Series.Add("Feb")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData(2, 3, 4, 3)
    'Create a new chart series with the name
    Dim serieMarch As IOfficeChartSerie = chart.Series.Add("March")
    'Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData(2, 4, 4, 4)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Enable error bar X for a serie
    chart.Series(0).HasErrorBarsX = True
    'Get the error bar X
    Dim errorBars As IOfficeChartErrorBars = chart.Series(0).ErrorBarsX
    'set the border line color
    errorBars.Border.LineColor = System.Drawing.Color.BlueViolet
    'Set the border line weight
    errorBars.Border.LineWeight = OfficeChartLineWeight.Wide
    'Set the type
    errorBars.Type = OfficeErrorBarType.StandardDeviation
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    Methods

    ClearFormats()

    Clears the formatting of the error bars.

    Declaration
    void ClearFormats()
    Examples
    IPresentation presentation = Presentation.Create();
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 500, 300);
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Create a new chart series with the name
    IOfficeChartSerie serieMarch = chart.Series.Add("March");
    //Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData[2, 4, 4, 4];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Enable error bar X for a serie
    chart.Series[0].HasErrorBarsX = true;
    //Get the error bar X
    IOfficeChartErrorBars errorBars = chart.Series[0].ErrorBarsX;
    //Set the type
    errorBars.Type = OfficeErrorBarType.StandardDeviation;
    //Set the cap for errorbars
    errorBars.HasCap = true;
    //Set the include property
    errorBars.Include = OfficeErrorBarInclude.Minus;
    //Clear formats
    errorBars.ClearFormats();
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();
    Dim presentation__1 As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentation__1.Slides.Add(SlideLayoutType.Blank)
    'Add chart to the slide with position and size
    Dim chart As IPresentationChart = slide.Charts.AddChart(100, 10, 500, 300)
    'Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan")
    chart.ChartData.SetValue(1, 3, "Feb")
    chart.ChartData.SetValue(1, 4, "March")
    'Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011")
    chart.ChartData.SetValue(2, 2, "60")
    chart.ChartData.SetValue(2, 3, "70")
    chart.ChartData.SetValue(2, 4, "80")
    'Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009")
    chart.ChartData.SetValue(3, 2, "80")
    chart.ChartData.SetValue(3, 3, "70")
    chart.ChartData.SetValue(3, 4, "60")
    'Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010")
    chart.ChartData.SetValue(4, 2, "60")
    chart.ChartData.SetValue(4, 3, "70")
    chart.ChartData.SetValue(4, 4, "80")
    'Create a new chart series with the name
    Dim serieJan As IOfficeChartSerie = chart.Series.Add("Jan")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData(2, 2, 4, 2)
    'Create a new chart series with the name
    Dim serieFeb As IOfficeChartSerie = chart.Series.Add("Feb")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData(2, 3, 4, 3)
    'Create a new chart series with the name
    Dim serieMarch As IOfficeChartSerie = chart.Series.Add("March")
    'Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData(2, 4, 4, 4)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Enable error bar X for a serie
    chart.Series(0).HasErrorBarsX = True
    'Get the error bar X
    Dim errorBars As IOfficeChartErrorBars = chart.Series(0).ErrorBarsX
    'Set the type
    errorBars.Type = OfficeErrorBarType.StandardDeviation
    'Set the cap for errorbars
    errorBars.HasCap = True
    'Set the include property
    errorBars.Include = OfficeErrorBarInclude.Minus
    'Clear formats
    errorBars.ClearFormats()
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    Delete()

    Deletes the error bars.

    Declaration
    void Delete()
    Examples
    IPresentation presentation = Presentation.Create();
    ISlide slide = presentation.Slides.Add(SlideLayoutType.Blank);
    //Add chart to the slide with position and size
    IPresentationChart chart = slide.Charts.AddChart(100, 10, 500, 300);
    //Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan");
    chart.ChartData.SetValue(1, 3, "Feb");
    chart.ChartData.SetValue(1, 4, "March");
    //Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011");
    chart.ChartData.SetValue(2, 2, "60");
    chart.ChartData.SetValue(2, 3, "70");
    chart.ChartData.SetValue(2, 4, "80");
    //Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009");
    chart.ChartData.SetValue(3, 2, "80");
    chart.ChartData.SetValue(3, 3, "70");
    chart.ChartData.SetValue(3, 4, "60");
    //Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010");
    chart.ChartData.SetValue(4, 2, "60");
    chart.ChartData.SetValue(4, 3, "70");
    chart.ChartData.SetValue(4, 4, "80");
    //Create a new chart series with the name
    IOfficeChartSerie serieJan = chart.Series.Add("Jan");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData[2, 2, 4, 2];
    //Create a new chart series with the name
    IOfficeChartSerie serieFeb = chart.Series.Add("Feb");
    //Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData[2, 3, 4, 3];
    //Create a new chart series with the name
    IOfficeChartSerie serieMarch = chart.Series.Add("March");
    //Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData[2, 4, 4, 4];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Enable error bar X for a serie
    chart.Series[0].HasErrorBarsX = true;
    //Get the error bar X
    IOfficeChartErrorBars errorBars = chart.Series[0].ErrorBarsX;
    //Set the type
    errorBars.Type = OfficeErrorBarType.StandardDeviation;
    //Set the cap for errorbars
    errorBars.HasCap = true;
    //Set the include property
    errorBars.Include = OfficeErrorBarInclude.Minus;
    //Delete the error bars
    errorBars.Delete();
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();
    Dim presentation__1 As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentation__1.Slides.Add(SlideLayoutType.Blank)
    'Add chart to the slide with position and size
    Dim chart As IPresentationChart = slide.Charts.AddChart(100, 10, 500, 300)
    'Set chart data - Row1
    chart.ChartData.SetValue(1, 2, "Jan")
    chart.ChartData.SetValue(1, 3, "Feb")
    chart.ChartData.SetValue(1, 4, "March")
    'Set chart data - Row2
    chart.ChartData.SetValue(2, 1, "2011")
    chart.ChartData.SetValue(2, 2, "60")
    chart.ChartData.SetValue(2, 3, "70")
    chart.ChartData.SetValue(2, 4, "80")
    'Set chart data - Row3
    chart.ChartData.SetValue(3, 1, "2009")
    chart.ChartData.SetValue(3, 2, "80")
    chart.ChartData.SetValue(3, 3, "70")
    chart.ChartData.SetValue(3, 4, "60")
    'Set chart data - Row4
    chart.ChartData.SetValue(4, 1, "2010")
    chart.ChartData.SetValue(4, 2, "60")
    chart.ChartData.SetValue(4, 3, "70")
    chart.ChartData.SetValue(4, 4, "80")
    'Create a new chart series with the name
    Dim serieJan As IOfficeChartSerie = chart.Series.Add("Jan")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieJan.Values = chart.ChartData(2, 2, 4, 2)
    'Create a new chart series with the name
    Dim serieFeb As IOfficeChartSerie = chart.Series.Add("Feb")
    'Set the data range of chart serie � start row, start column, end row, end column
    serieFeb.Values = chart.ChartData(2, 3, 4, 3)
    'Create a new chart series with the name
    Dim serieMarch As IOfficeChartSerie = chart.Series.Add("March")
    'Set the data range of chart series � start row, start column, end row, end column
    serieMarch.Values = chart.ChartData(2, 4, 4, 4)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Enable error bar X for a serie
    chart.Series(0).HasErrorBarsX = True
    'Get the error bar X
    Dim errorBars As IOfficeChartErrorBars = chart.Series(0).ErrorBarsX
    'Set the type
    errorBars.Type = OfficeErrorBarType.StandardDeviation
    'Set the cap for errorbars
    errorBars.HasCap = True
    'Set the include property
    errorBars.Include = OfficeErrorBarInclude.Minus
    'Delete the error bars
    errorBars.Delete()
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved