Funnel Chart

Funnel charts are the charts that help in visualizing the 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 following stage smaller than the predecessor.

Funnel charts are useful in identifying potential problem areas in processes where it is noticeable at what stages and rate the values decrease.

Sample Image	Description
	ChartType.Funnel Represents a funnel chart. It is used to visualize the sequential stages in a linear process such as the recruitment process, order fulfillment cycles, and promotional campaigns.

Sample Image

Description

ChartType.Funnel

Represents a funnel chart.

It is used to visualize the sequential stages in a linear process such as the recruitment process, order fulfillment cycles, and promotional campaigns.

Using Code

Refer to the following example code to add a funnel chart.

// Funnel chart.
object[,] dataArray = {
     {"Stage", "Amount"},
 {"Prospect", 500},
 {"Qualified Prospects", 425},
 {"Needs Analysis", 200},
 {"Price Quotes", 150},
 {"Negotiations", 100},
 {"Closed Sales", 90}
         };
for (int i = 0; i < dataArray.GetLength(0); i++)
{
     for (int j = 0; j < dataArray.GetLength(1); j++)
     {
         spreadSheet1.Workbook.ActiveSheet.Cells[i, j].Value = dataArray[i, j];
     }
}
spreadSheet1.Workbook.ActiveSheet.Cells["A1:B7"].Select();
spreadSheet1.Workbook.ActiveSheet.Shapes.AddChart(GrapeCity.Spreadsheet.Charts.ChartType.Funnel, 100, 150, 400, 300, false);
spreadSheet1.Workbook.ActiveSheet.ChartObjects[0].Chart.ShowTitle();
spreadSheet1.Workbook.ActiveSheet.ChartObjects[0].Chart.ChartTitle.Text = "Funnel Chart";

' Funnel chart.
Dim dataArray = {
         {"Stage", "Amount"},
     {"Prospect", 500},
     {"Qualified Prospects", 425},
     {"Needs Analysis", 200},
     {"Price Quotes", 150},
     {"Negotiations", 100},
              {"Closed Sales", 90}}
For i = 0 To dataArray.GetLength(0) - 1
        For j = 0 To dataArray.GetLength(1) - 1
            spreadSheet1.Workbook.ActiveSheet.Cells(i, j).Value = dataArray(i, j)
        Next
Next
spreadSheet1.Workbook.ActiveSheet.Cells("A1:B7").[Select](gcdocsite__documentlink?toc-item-id=92c6db4a-7e95-4a08-9eba-73fd7f0ff98a)
spreadSheet1.Workbook.ActiveSheet.Shapes.AddChart(GrapeCity.Spreadsheet.Charts.ChartType.Funnel, 100, 150, 400, 300, False)
spreadSheet1.Workbook.ActiveSheet.ChartObjects(0).Chart.ShowTitle()
spreadSheet1.Workbook.ActiveSheet.ChartObjects(0).Chart.ChartTitle.Text = "Funnel Chart"