Funnel | Document Solutions for Excel, .NET Edition

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); }

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);
  }