Documents for Excel, .NET Edition Documentation
Manage Data / Use Chart / Work with Chart Types / Specialized Chart / Funnel
In This Topic
    Funnel
    In This Topic

    Funnel charts help in visualizing sequential stages in a linear process such as order fulfillment. In such processes, each stage represents a proportion (percentage) of the total. Therefore, the chart takes the funnel shape with the first stage being the largest and each subsequent stage smaller than the predecessor. The Funnel charts can be used to represent stages in a sales process and represent the amount of potential revenue for each stage. This type of chart is useful in finding potential problem areas in an organization's sales processes. For instance, with Funnel charts, a user can plot the order fulfillment process that tracks number of orders getting across a stage.

    Using Code

    Refer to the following code to add a Funnel chart:

    C#
    Copy Code
      public void FunnelChart()
      {
          // Initialize workbook
          Workbook workbook = new Workbook();
          // Fetch default worksheet 
          IWorksheet worksheet = workbook.Worksheets[0];
    
          // Prepare data for chart
          worksheet.Range["A1:B9"].Value = new object[,]
    {
         {null, "Sales"},
         {"Consultation", 140000},
         {"Prospects", 120000},
         {"Qualified", 100000},
         {"Negotiations", 80000},
         {"Prototype", 60000},
         {"Closing", 40000},
         {"Won", 20000},
         {"Finalized", 10000}
    };
          worksheet.Range["A:B"].Columns.AutoFit();
    
          // Add Funnel Chart
          IShape funnelChartshape = worksheet.Shapes.AddChart(ChartType.Funnel, 300, 20, 300, 200);
          funnelChartshape.Chart.SeriesCollection.Add(worksheet.Range["A1:B9"]);
    
          // Configure Chart Title 
          funnelChartshape.Chart.ChartTitle.Text = "Sales Pipeline";
    
          // Configure Axis
          IAxis axis = funnelChartshape.Chart.Axes.Item(AxisType.Category, AxisGroup.Primary);
          axis.Visible = true;
    
          // Saving workbook to Xlsx
          workbook.Save(@"34-FunnelChart.xlsx", SaveFileFormat.Xlsx);
      }