menu

WinForms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface IOfficeChartSerie - WindowsForms API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface IOfficeChartSerie

    Represents a series in a chart.

    Inherited Members
    IParentApplication.Parent
    Namespace: Syncfusion.OfficeChart
    Assembly: Syncfusion.OfficeChart.Base.dll
    Syntax
    public interface IOfficeChartSerie : IParentApplication

    Properties

    Bubbles

    Gets or sets the range of bubble sizes of the bubble chart.

    Declaration
    IOfficeDataRange Bubbles { get; set; }
    Property Value
    Type
    IOfficeDataRange
    Examples
    //Creates a Presentation instance
    IPresentation presentation = Presentation.Open("BubbleChart.pptx");
    ISlide slide = presentation.Slides[0];
    IPresentationChart chart = slide.Charts[0];
    //Retrieves the range of bubble sizes of the chart
    IOfficeDataRange dataRange = chart.Series[0].Bubbles;
    //Changes the bubble size in a specific cell within the data range.
    dataRange.SetValue(dataRange.FirstRow, dataRange.FirstColumn, 20);
    //Saves the presentation
    presentation.Save("Output.pptx");
    //Closes the presentation
     presentation.Close();
    'Creates a Presentation instance
    Dim presentationDocument As IPresentation = Presentation.Open("BubbleChart.pptx")
    Dim slide As ISlide = presentationDocument.Slides(0)
    Dim chart As IPresentationChart = slide.Charts(0)
    'Retrieves the range of bubble sizes of the chart
    Dim dataRange As IOfficeDataRange = chart.Series(0).Bubbles
    'Changes the bubble size in a specific cell within the data range.
    dataRange.SetValue(dataRange.FirstRow, dataRange.FirstColumn, 20)
    'Saves the presentation
    presentationDocument.Save("Output.pptx")
    'Closes the presentation
    presentationDocument.Close()

    CategoryLabels

    Gets or sets the range of category labels of the series.

    Declaration
    IOfficeDataRange CategoryLabels { get; set; }
    Property Value
    Type
    IOfficeDataRange
    Examples
    //Creates a Presentation instance
    IPresentation presentation = Presentation.Open("BubbleChart.pptx");
    ISlide slide = presentation.Slides[0];
    IPresentationChart chart = slide.Charts[0];
    //Retrieves the range of category labels
    IOfficeDataRange dataRange = chart.Series[0].CategoryLabels;
    //Changes the category label of a specific cell within the data range.
    dataRange.SetValue(dataRange.FirstRow, dataRange.FirstColumn, 2.4);
    //Saves the presentation
    presentation.Save("Output.pptx");
    //Closes the presentation
     presentation.Close();
    'Creates a Presentation instance
    Dim presentationDocument As IPresentation = Presentation.Open("BubbleChart.pptx")
    Dim slide As ISlide = presentationDocument.Slides(0)
    Dim chart As IPresentationChart = slide.Charts(0)
    Retrieves the range of category labels
    Dim dataRange As IOfficeDataRange = chart.Series(0).CategoryLabels
    'Changes the category label of a specific cell within the data range.
    dataRange.SetValue(dataRange.FirstRow, dataRange.FirstColumn, 2.4)
    'Saves the presentation
    presentationDocument.Save("Output.pptx")
    'Closes the presentation
    presentationDocument.Close()

    DataPoints

    Gets the collection of data points of the series. Read-only.

    Declaration
    IOfficeChartDataPoints DataPoints { get; }
    Property Value
    Type
    IOfficeChartDataPoints
    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];
    //Get the series data points
    IOfficeChartDataPoints dataPoints = chart.Series[0].DataPoints;
    //Get the data point using the index, read only
    IOfficeChartDataPoint dataPoint = dataPoints[0];
    //Get the data labels of data point
    IOfficeChartDataLabels dataLabels = dataPoint.DataLabels;
    //Set the position of the data label
    dataLabels.Position = OfficeDataLabelPosition.Center;
    //Set the series name
    dataLabels.IsSeriesName = true;
    //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)
    'Get the series data points
    Dim dataPoints As IOfficeChartDataPoints = chart.Series(0).DataPoints
    'Get the data point using the index, read only
    Dim dataPoint As IOfficeChartDataPoint = dataPoints(0)
    'Get the data labels of data point
    Dim dataLabels As IOfficeChartDataLabels = dataPoint.DataLabels
    'Set the position of the data label
    dataLabels.Position = OfficeDataLabelPosition.Center
    'Set the series name
    dataLabels.IsSeriesName = True
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    ErrorBarsX

    Gets the IOfficeChartErrorBars object that represents vertical error bars. Read-only.

    Declaration
    IOfficeChartErrorBars ErrorBarsX { get; }
    Property Value
    Type
    IOfficeChartErrorBars
    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 as Scatter line
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Set the error Bar X
    serieJan.HasErrorBarsX = true;
    //Set the color of error barX border
    serieJan.ErrorBarsX.Border.LineColor = System.Drawing.Color.Red;
    //Set the has cap
    serieJan.ErrorBarsX.HasCap = true;
    //Set the include 
    serieJan.ErrorBarsX.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 as Scatter line
    chart.ChartType = OfficeChartType.Scatter_Line
    'Set the error Bar X
    serieJan.HasErrorBarsX = True
    'Set the color of error barX border
    serieJan.ErrorBarsX.Border.LineColor = System.Drawing.Color.Red
    'Set the has cap
    serieJan.ErrorBarsX.HasCap = True
    'Set the include 
    serieJan.ErrorBarsX.Include = OfficeErrorBarInclude.Minus
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    ErrorBarsY

    Gets the IOfficeChartErrorBars object that represents horizontal error bars. Read-only.

    Declaration
    IOfficeChartErrorBars ErrorBarsY { get; }
    Property Value
    Type
    IOfficeChartErrorBars
    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 as Scatter line
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Set the error Bar Y
    serieJan.HasErrorBarsY = true;
    //Set the color of error barX border
    serieJan.ErrorBarsY.Border.LineColor = System.Drawing.Color.Red;
    //Set the has cap
    serieJan.ErrorBarsY.HasCap = true;
    //Set the include 
    serieJan.ErrorBarsY.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 as Scatter line
    chart.ChartType = OfficeChartType.Scatter_Line
    'Set the error Bar Y
    serieJan.HasErrorBarsY = True
    'Set the color of error barX border
    serieJan.ErrorBarsY.Border.LineColor = System.Drawing.Color.Red
    'Set the has cap
    serieJan.ErrorBarsY.HasCap = True
    'Set the include 
    serieJan.ErrorBarsY.Include = OfficeErrorBarInclude.Minus
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    HasErrorBarsX

    Gets or sets a value that Indicates the series contains X error bars.

    Declaration
    bool HasErrorBarsX { get; set; }
    Property Value
    Type Description
    System.Boolean

    Trueif series contains X error bars.Otherwise False.

    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 as Scatter line
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Set the error Bar X
    serieJan.HasErrorBarsX = true;
    //Set the color of error barX border
    serieJan.ErrorBarsX.Border.LineColor = System.Drawing.Color.Red;
    //Set the has cap
    serieJan.ErrorBarsX.HasCap = true;
    //Set the include 
    serieJan.ErrorBarsX.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 as Scatter line
    chart.ChartType = OfficeChartType.Scatter_Line
    'Set the error Bar X
    serieJan.HasErrorBarsX = True
    'Set the color of error barX border
    serieJan.ErrorBarsX.Border.LineColor = System.Drawing.Color.Red
    'Set the has cap
    serieJan.ErrorBarsX.HasCap = True
    'Set the include 
    serieJan.ErrorBarsX.Include = OfficeErrorBarInclude.Minus
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    HasErrorBarsY

    Gets or sets a value that Indicates the series contains Y error bars.

    Declaration
    bool HasErrorBarsY { get; set; }
    Property Value
    Type Description
    System.Boolean

    Trueif series contains Y error bars.Otherwise False.

    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 as Scatter line
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Set the error Bar Y
    serieJan.HasErrorBarsY = true;
    //Set the color of error barX border
    serieJan.ErrorBarsY.Border.LineColor = System.Drawing.Color.Red;
    //Set the has cap
    serieJan.ErrorBarsY.HasCap = true;
    //Set the include 
    serieJan.ErrorBarsY.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 as Scatter line
    chart.ChartType = OfficeChartType.Scatter_Line
    'Set the error Bar Y
    serieJan.HasErrorBarsY = True
    'Set the color of error barX border
    serieJan.ErrorBarsY.Border.LineColor = System.Drawing.Color.Red
    'Set the has cap
    serieJan.ErrorBarsY.HasCap = True
    'Set the include 
    serieJan.ErrorBarsY.Include = OfficeErrorBarInclude.Minus
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    InvertIfNegative

    Gets or sets a value to specify the series to invert its colors if the value is negative. The default value is true.

    Declaration
    bool InvertIfNegative { get; set; }
    Property Value
    Type
    System.Boolean
    Examples
    IPresentation presentationDocument = Presentation.Create();
    ISlide slide = presentationDocument.Slides.Add(SlideLayoutType.Blank);
    //Loads the excel file as stream
    Stream excelStream = File.OpenRead("Excel_Template.xlsx");
    //Creates and Appends chart to the paragraph with excel stream as parameter
    IPresentationChart chart = slide.Shapes.AddChart(excelStream, 1, "A1:C6", new RectangleF(0, 0, 470, 300));
    foreach (IOfficeChartSerie serie in chart.Series)
    {
    serie.InvertIfNegative = false;
    }
    chart.PrimaryCategoryAxis.CategoryLabels = chart.ChartData[2, 1, 6, 1];
    //Sets chart type and title
    chart.ChartType = OfficeChartType.Bar_Clustered;
    chart.ChartTitle = "Purchase Details";
    chart.ChartTitleArea.FontName = "Calibri";
    chart.ChartTitleArea.Size = 14;
    chart.PrimaryValueAxis.CrossesAt = 1500;
    presentationDocument.Save("Output.pptx");
    presentationDocument.Close();
    Dim presentationDocument As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentationDocument.Slides.Add(SlideLayoutType.Blank)
    'Loads the excel file as stream
    Dim excelStream As Stream = File.OpenRead("Excel_Template.xlsx")
    'Creates and Appends chart to the paragraph with excel stream as parameter
    Dim chart As IPresentationChart = slide.Shapes.AddChart(excelStream, 1, "A1:C6", New RectangleF(0, 0, 470, 300))
    For Each serie As IOfficeChartSerie In chart.Series
    serie.InvertIfNegative = False
    Next
    chart.PrimaryCategoryAxis.CategoryLabels = chart.ChartData(2, 1, 6, 1)
    'Sets chart type and title
    chart.ChartType = OfficeChartType.Bar_Clustered
    chart.ChartTitle = "Purchase Details"
    chart.ChartTitleArea.FontName = "Calibri"
    chart.ChartTitleArea.Size = 14
    chart.PrimaryValueAxis.CrossesAt = 1500
    presentationDocument.Save("Output.pptx")
    presentationDocument.Close()

    InvertIfNegativeColor

    Gets or sets a value to specify the series to invert its colors if the value is negative.

    Declaration
    ChartColor InvertIfNegativeColor { get; set; }
    Property Value
    Type
    ChartColor
    Examples
    IPresentation presentationDocument = Presentation.Create();
    ISlide slide = presentationDocument.Slides.Add(SlideLayoutType.Blank);
    //Loads the excel file as stream
    Stream excelStream = File.OpenRead("Excel_Template.xlsx");
    //Creates and Appends chart to the paragraph with excel stream as parameter
    IPresentationChart chart = slide.Shapes.AddChart(excelStream, 1, "A1:C6", new RectangleF(0, 0, 470, 300));
    foreach (IOfficeChartSerie serie in chart.Series)
    {
    serie.InvertIfNegative = true;
    series.InvertIfNegativeColor = Color.Red;
    }
    chart.PrimaryCategoryAxis.CategoryLabels = chart.ChartData[2, 1, 6, 1];
    //Sets chart type and title
    chart.ChartType = OfficeChartType.Bar_Clustered;
    chart.ChartTitle = "Purchase Details";
    chart.ChartTitleArea.FontName = "Calibri";
    chart.ChartTitleArea.Size = 14;
    chart.PrimaryValueAxis.CrossesAt = 1500;
    presentationDocument.Save("Output.pptx");
    presentationDocument.Close();
    Dim presentationDocument As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentationDocument.Slides.Add(SlideLayoutType.Blank)
    'Loads the excel file as stream
    Dim excelStream As Stream = File.OpenRead("Excel_Template.xlsx")
    'Creates and Appends chart to the paragraph with excel stream as parameter
    Dim chart As IPresentationChart = slide.Shapes.AddChart(excelStream, 1, "A1:C6", New RectangleF(0, 0, 470, 300))
    For Each serie As IOfficeChartSerie In chart.Series
    serie.InvertIfNegative = False
    series.InvertIfNegativeColor = Color.Red
    Next
    chart.PrimaryCategoryAxis.CategoryLabels = chart.ChartData(2, 1, 6, 1)
    'Sets chart type and title
    chart.ChartType = OfficeChartType.Bar_Clustered
    chart.ChartTitle = "Purchase Details"
    chart.ChartTitleArea.FontName = "Calibri"
    chart.ChartTitleArea.Size = 14
    chart.PrimaryValueAxis.CrossesAt = 1500
    presentationDocument.Save("Output.pptx")
    presentationDocument.Close()

    IsFiltered

    Returns or sets a value that determines whether the specified chart series is filtered out from the chart.

    Declaration
    bool IsFiltered { 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];
    //Filter the serie value 
    serieJan.IsFiltered = true;           
    //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)
    'Filter the serie value 
    serieJan.IsFiltered = True
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    Name

    Gets or sets the name of the series.

    Declaration
    string Name { get; set; }
    Property Value
    Type
    System.String
    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 as Radar
    chart.ChartType = OfficeChartType.Radar;
    //Reset the name of the serie
    serieFeb.Name = "February";
    //Get the Serie Format
    IOfficeChartSerieDataFormat serieFormat = serieFeb.SerieFormat;
    //Set the radar axis labels
    serieFormat.CommonSerieOptions.HasRadarAxisLabels = true; 
    //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 as Radar
    chart.ChartType = OfficeChartType.Radar
    'Reset the name of the serie
    serieFeb.Name = "February"
    'Get the Serie Format
    Dim serieFormat As IOfficeChartSerieDataFormat = serieFeb.SerieFormat
    'Set the radar axis labels
    serieFormat.CommonSerieOptions.HasRadarAxisLabels = True
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    NameRange

    Gets the Name range of the series.

    Declaration
    IOfficeDataRange NameRange { get; }
    Property Value
    Type
    IOfficeDataRange
    Examples
    //Creates a Presentation instance
    IPresentation presentation = Presentation.Open("BubbleChart.pptx");
    ISlide slide = presentation.Slides[0];
    IPresentationChart chart = slide.Charts[0];
    //Retrieves the name range of the series
    IOfficeDataRange dataRange = chart.Series[0].NameRange;
    //Sets a new name to the series
    dataRange.SetValue(dataRange.FirstRow, dataRange.FirstColumn, "My serie Name");
    //Saves the presentation
    presentation.Save("Output.pptx");
    //Closes the presentation
    presentation.Close();
    'Creates a Presentation instance
    Dim presentationDocument As IPresentation = Presentation.Open("BubbleChart.pptx")
    Dim slide As ISlide = presentationDocument.Slides(0)
    Dim chart As IPresentationChart = slide.Charts(0)
    'Retrieves the name range of the series
    Dim dataRange As IOfficeDataRange = chart.Series(0).NameRange
    'Sets a new name to the series
    dataRange.SetValue(dataRange.FirstRow, dataRange.FirstColumn, "My serie Name")
    'Saves the presentation
    presentationDocument.Save("Output.pptx")
    'Closes the presentation
    presentationDocument.Close()

    ParetoLineFormat

    Gets the Pareto line on the Pareto charts. Read-only.

    Declaration
    IOfficeChartFrameFormat ParetoLineFormat { get; }
    Property Value
    Type
    IOfficeChartFrameFormat

    SerieFormat

    Gets the IOfficeChartSerieDataFormat object that represents formatting settings of the series.Read-only.

    Declaration
    IOfficeChartSerieDataFormat SerieFormat { get; }
    Property Value
    Type
    IOfficeChartSerieDataFormat
    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 as Radar
    chart.ChartType = OfficeChartType.Radar;
    //Reset the name of the serie
    serieFeb.Name = "February";
    //Get the Serie Format
    IOfficeChartSerieDataFormat serieFormat = serieFeb.SerieFormat;
    //Set the radar axis labels
    serieFormat.CommonSerieOptions.HasRadarAxisLabels = true; 
    //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 as Radar
    chart.ChartType = OfficeChartType.Radar
    'Reset the name of the serie
    serieFeb.Name = "February"
    'Get the Serie Format
    Dim serieFormat As IOfficeChartSerieDataFormat = serieFeb.SerieFormat
    'Set the radar axis labels
    serieFormat.CommonSerieOptions.HasRadarAxisLabels = True
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    SerieType

    Gets or sets a series type for the series.

    Declaration
    OfficeChartType SerieType { get; set; }
    Property Value
    Type
    OfficeChartType
    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 serie type for each serie
    serieFeb.SerieType = OfficeChartType.Line;
    serieJan.SerieType = OfficeChartType.Area;
    serieMarch.SerieType = OfficeChartType.Bar_Clustered;
    //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 serie type for each serie
    serieFeb.SerieType = OfficeChartType.Line
    serieJan.SerieType = OfficeChartType.Area
    serieMarch.SerieType = OfficeChartType.Bar_Clustered
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    TrendLines

    Gets the trend lines collection of the series. Read-only.

    Declaration
    IOfficeChartTrendLines TrendLines { get; }
    Property Value
    Type
    IOfficeChartTrendLines
    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 primary axis for the serie
    serieMarch.UsePrimaryAxis = true;
    //Add the trendline to chart serie 
    serieJan.TrendLines.Add();
    serieJan.TrendLines.Add(OfficeTrendLineType.Moving_Average);
    //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 primary axis for the serie
    serieMarch.UsePrimaryAxis = True
    'Add the trendline to chart serie 
    serieJan.TrendLines.Add()
    serieJan.TrendLines.Add(OfficeTrendLineType.Moving_Average)
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    UsePrimaryAxis

    Gets or Sets a value that Indicates whether to use primary axis for series drawing.

    Declaration
    bool UsePrimaryAxis { get; set; }
    Property Value
    Type Description
    System.Boolean

    True if use primary axis.Otherwise False.

    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 primary axis for the serie
    serieMarch.UsePrimaryAxis = true;
    //Add the trendline to chart serie 
    serieJan.TrendLines.Add();
    serieJan.TrendLines.Add(OfficeTrendLineType.Moving_Average);
    //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 primary axis for the serie
    serieMarch.UsePrimaryAxis = True
    'Add the trendline to chart serie 
    serieJan.TrendLines.Add()
    serieJan.TrendLines.Add(OfficeTrendLineType.Moving_Average)
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    Values

    Gets or sets the value range of the series.

    Declaration
    IOfficeDataRange Values { get; set; }
    Property Value
    Type
    IOfficeDataRange
    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];
    //Save the presentation
    presentation.Save("Output.pptx");
    //Close the presentation
    presentation.Close();
    Dim presentationDocument As IPresentation = Presentation.Create()
    Dim slide As ISlide = presentationDocument.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)
    'Save the presentation
    presentationDocument.Save("Output.pptx")
    'Close the presentation
    presentationDocument.Close()

    Methods

    ErrorBar(Boolean)

    Creates error bar for the series.

    Declaration
    IOfficeChartErrorBars ErrorBar(bool bIsY)
    Parameters
    Type Name Description
    System.Boolean bIsY

    If true - on Y axis; otherwise on X axis.

    Returns
    Type Description
    IOfficeChartErrorBars

    Returns error bar object of the series.

    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];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Add error bars to series
    serieJan.ErrorBar(true);
    serieFeb.ErrorBar(false);
    //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)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Add error bars to series
    serieJan.ErrorBar(True)
    serieFeb.ErrorBar(False)
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    ErrorBar(Boolean, IOfficeDataRange, IOfficeDataRange)

    Creates error bar for the series.

    Declaration
    IOfficeChartErrorBars ErrorBar(bool bIsY, IOfficeDataRange plusRange, IOfficeDataRange minusRange)
    Parameters
    Type Name Description
    System.Boolean bIsY

    If true - on Y axis; otherwise on X axis.

    IOfficeDataRange plusRange

    Represents plus range.

    IOfficeDataRange minusRange

    Represents minus range.

    Returns
    Type Description
    IOfficeChartErrorBars

    Returns error bar object.

    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];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Set the error bar X for serie
    serieJan.HasErrorBarsX = true;
    //Set the plus range
    serieJan.ErrorBarsX.PlusRange = chart.ChartData[2, 2, 4, 2];
    //Set the minus range
    serieJan.ErrorBarsX.MinusRange = chart.ChartData[2, 3, 4, 3];
    //Add Error bar to serie
    serieJan.ErrorBar(true, serieJan.ErrorBarsX.PlusRange, serieJan.ErrorBarsX.MinusRange);
    //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)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Set the error bar X for serie
    serieJan.HasErrorBarsX = True
    'Set the plus range
    serieJan.ErrorBarsX.PlusRange = chart.ChartData(2, 2, 4, 2)
    'Set the minus range
    serieJan.ErrorBarsX.MinusRange = chart.ChartData(2, 3, 4, 3)
    'Add Error bar to serie
    serieJan.ErrorBar(True, serieJan.ErrorBarsX.PlusRange, serieJan.ErrorBarsX.MinusRange)
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    ErrorBar(Boolean, OfficeErrorBarInclude)

    Creates error bar for the series.

    Declaration
    IOfficeChartErrorBars ErrorBar(bool bIsY, OfficeErrorBarInclude include)
    Parameters
    Type Name Description
    System.Boolean bIsY

    If true - on Y axis; otherwise on X axis.

    OfficeErrorBarInclude include

    Represents include type.

    Returns
    Type Description
    IOfficeChartErrorBars

    Return error bar object of the series.

    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];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Add error bars to series
    serieJan.ErrorBar(true,OfficeErrorBarInclude.Both);
    serieFeb.ErrorBar(false,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)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Add error bars to series
    serieJan.ErrorBar(True, OfficeErrorBarInclude.Both)
    serieFeb.ErrorBar(False, OfficeErrorBarInclude.Minus)
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    ErrorBar(Boolean, OfficeErrorBarInclude, OfficeErrorBarType)

    Creates error bar for the series.

    Declaration
    IOfficeChartErrorBars ErrorBar(bool bIsY, OfficeErrorBarInclude include, OfficeErrorBarType type)
    Parameters
    Type Name Description
    System.Boolean bIsY

    If true - on Y axis; otherwise on X axis.

    OfficeErrorBarInclude include

    Represents include type.

    OfficeErrorBarType type

    Represents error bar type.

    Returns
    Type Description
    IOfficeChartErrorBars

    Return error bar object.

    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];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Add error bars to series
    serieJan.ErrorBar(true, OfficeErrorBarInclude.Both, OfficeErrorBarType.StandardDeviation);
    serieFeb.ErrorBar(false, OfficeErrorBarInclude.Plus, OfficeErrorBarType.StandardError);   
    //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)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Add error bars to series
    serieJan.ErrorBar(True, OfficeErrorBarInclude.Both, OfficeErrorBarType.StandardDeviation)
    serieFeb.ErrorBar(False, OfficeErrorBarInclude.Plus, OfficeErrorBarType.StandardError)
    'Save the presentation
    presentation__1.Save("Output.pptx")
    'Close the presentation
    presentation__1.Close()

    ErrorBar(Boolean, OfficeErrorBarInclude, OfficeErrorBarType, Double)

    Creates error bar for the series.

    Declaration
    IOfficeChartErrorBars ErrorBar(bool bIsY, OfficeErrorBarInclude include, OfficeErrorBarType type, double numberValue)
    Parameters
    Type Name Description
    System.Boolean bIsY

    If true - on Y axis; otherwise on X axis.

    OfficeErrorBarInclude include

    Represents include type.

    OfficeErrorBarType type

    Represents error bar type.

    System.Double numberValue

    Represents number value.

    Returns
    Type Description
    IOfficeChartErrorBars

    Return error bar object.

    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];
    //Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line;
    //Add error bars to series
    serieJan.ErrorBar(true, OfficeErrorBarInclude.Both, OfficeErrorBarType.StandardDeviation, 12.34);
    serieFeb.ErrorBar(false, OfficeErrorBarInclude.Plus, OfficeErrorBarType.StandardError, 25.89);   
    //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)
    'Set the chart type
    chart.ChartType = OfficeChartType.Scatter_Line
    'Add error bars to series
    serieJan.ErrorBar(True, OfficeErrorBarInclude.Both, OfficeErrorBarType.StandardDeviation, 12.34)
    serieFeb.ErrorBar(False, OfficeErrorBarInclude.Plus, OfficeErrorBarType.StandardError, 25.89)
    '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