FunnelSeries Class

Displays data as a funnel chart.

Namespace: DevExpress.Docs.Office

Assembly: DevExpress.Docs.Core.v26.1.dll

NuGet Package: DevExpress.Docs.Core

Declaration

C#

public class FunnelSeries :
    DataSeriesExBase

VB.NET

Public Class FunnelSeries
    Inherits DataSeriesExBase

Related API Members

The following members return FunnelSeries objects:

• FunnelSeries.Clone()

Remarks

For additional information about ChartEx series, refer to the following help topic: DevExpress Presentation API: Get Started with ChartEx (Office 2016 and later).

The following code snippet creates a funnel chart and adds it to a presentation slide:

C#

using DevExpress.Docs.Presentation;
using DevExpress.Docs.Office;
using System.Drawing;

namespace PresentationApiSample;

public class Program {
    public static async Task Main(string[] _) {
        // Create a presentation.
        Presentation presentation = new Presentation();

        // Reset the slide collection.
        presentation.Slides.Clear();

        // Add a blank slide.
        Slide slide = new Slide(SlideLayoutType.Blank);
        presentation.Slides.Add(slide);

        // Insert a chart on the slide.
        ChartEx chart = new ChartEx();
        slide.Shapes.Add(chart);

        // Set chart size to match the slide.
        chart.Width = presentation.SlideSize.Width;
        chart.Height = presentation.SlideSize.Height;

        // Populate category labels.
        chart.Data[0, "A1"].TextValue = "Category A";
        chart.Data[0, "A2"].TextValue = "Category B";
        chart.Data[0, "A3"].TextValue = "Category C";
        chart.Data[0, "A4"].TextValue = "Category D";
        chart.Data[0, "A5"].TextValue = "Category E";

        // Populate funnel values.
        chart.Data[0, "C1"].NumericValue = 129;
        chart.Data[0, "C2"].NumericValue = 110;
        chart.Data[0, "C3"].NumericValue = 97;
        chart.Data[0, "C4"].NumericValue = 71;
        chart.Data[0, "C5"].NumericValue = 50;

        // Create a funnel series and bind it to worksheet ranges.
        FunnelSeries series = new FunnelSeries();
        series.Arguments = new ChartDataReference("A1", "A5");
        series.Values = new ChartDataReference("C1", "C5");
        chart.Series.Add(series);

        // Display and format data labels.
        series.DataLabels.ShowValue = true;
        series.DataLabels.TextProperties = new TextProperties { FontSize = 24 };

        // Save the result to a file.
        var outputPath = @"D:\presentation.pptx";
        using FileStream outputStream = new(outputPath, FileMode.Create, FileAccess.Write, FileShare.None);
        presentation.SaveDocument(outputStream);
    }
}

VB.NET

Imports DevExpress.Docs.Presentation
Imports DevExpress.Docs.Office
Imports System.Drawing
Imports System.IO
Imports System.Threading.Tasks

Namespace PresentationApiSample

  Public Class Program
    Public Shared Async Function Main(args As String()) As Task
      ' Create a presentation.
      Dim presentation As New Presentation()

      ' Reset the slide collection.
      presentation.Slides.Clear()

      ' Add a blank slide.
      Dim slide As New Slide(SlideLayoutType.Blank)
      presentation.Slides.Add(slide)

      ' Insert a chart on the slide.
      Dim chart As New ChartEx()
      slide.Shapes.Add(chart)

      ' Set chart size to match the slide.
      chart.Width = presentation.SlideSize.Width
      chart.Height = presentation.SlideSize.Height

      ' Populate category labels.
      chart.Data(0, "A1").TextValue = "Category A"
      chart.Data(0, "A2").TextValue = "Category B"
      chart.Data(0, "A3").TextValue = "Category C"
      chart.Data(0, "A4").TextValue = "Category D"
      chart.Data(0, "A5").TextValue = "Category E"

      ' Populate funnel values.
      chart.Data(0, "C1").NumericValue = 129
      chart.Data(0, "C2").NumericValue = 110
      chart.Data(0, "C3").NumericValue = 97
      chart.Data(0, "C4").NumericValue = 71
      chart.Data(0, "C5").NumericValue = 50

      ' Create a funnel series and bind it to worksheet ranges.
      Dim series As New FunnelSeries()
      series.Arguments = New ChartDataReference("A1", "A5")
      series.Values = New ChartDataReference("C1", "C5")
      chart.Series.Add(series)

      ' Display and format data labels.
      series.DataLabels.ShowValue = True
      series.DataLabels.TextProperties = New TextProperties With {.FontSize = 24}

      ' Save the result to a file.
      Dim outputPath = "D:\presentation.pptx"
      Using outputStream As New FileStream(outputPath, FileMode.Create, FileAccess.Write, FileShare.None)
        presentation.SaveDocument(outputStream)
      End Using
    End Function
  End Class
End Namespace

Implements

ICloneable

Inheritance

Object

OfficeObject

SeriesExBase

DataSeriesExBase

FunnelSeries