[]
DEMOS DOCS API BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

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.

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

C#

// Enable enhanced shape and chart engines.
fpSpread1.Features.EnhancedShapeEngine = true;
fpSpread1.Features.EnhancedChartEngine = true;
// 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++)
   {
       fpSpread1.AsWorkbook().ActiveSheet.Cells[i, j].Value = dataArray[i, j];
   }
}
fpSpread1.AsWorkbook().ActiveSheet.Cells["A1:B7"].Select();
fpSpread1.AsWorkbook().ActiveSheet.Shapes.AddChart(GrapeCity.Spreadsheet.Charts.ChartType.Funnel, 100, 150, 400, 300, false);
fpSpread1.AsWorkbook().ActiveSheet.ChartObjects[0].Chart.ShowTitle();
fpSpread1.AsWorkbook().ActiveSheet.ChartObjects[0].Chart.ChartTitle.Text = "Funnel Chart";

VB

' Enable enhanced shape and chart engines.
fpSpread1.Features.EnhancedShapeEngine = True
fpSpread1.Features.EnhancedChartEngine = True
' Funnel chart.
Dim dataArray As Object(,) = {
    {"Stage", "Amount"},
    {"Prospect", 500},
    {"Qualified Prospects", 425},
    {"Needs Analysis", 200},
    {"Price Quotes", 150},
    {"Negotiations", 100},
    {"Closed Sales", 90}
}
For i As Integer = 0 To dataArray.GetLength(0) - 1
    For j As Integer = 0 To dataArray.GetLength(1) - 1
        fpSpread1.AsWorkbook().ActiveSheet.Cells(i, j).Value = dataArray(i, j)
    Next
Next
fpSpread1.AsWorkbook().ActiveSheet.Cells("A1:B7").Select()
fpSpread1.AsWorkbook().ActiveSheet.Shapes.AddChart(GrapeCity.Spreadsheet.Charts.ChartType.Funnel, 100, 150, 400, 300, False)
fpSpread1.AsWorkbook().ActiveSheet.ChartObjects(0).Chart.ShowTitle()
fpSpread1.AsWorkbook().ActiveSheet.ChartObjects(0).Chart.ChartTitle.Text = "Funnel Chart"