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

Pareto Chart

Pareto charts graphically summarize the process problems in ranking order from the most frequent to the least one. These charts contain both a bar and a line chart where bar chart values are plotted in decreasing order of relative frequency while the line chart plots the cumulative total percentage of frequencies. Pareto charts are useful for task prioritizing.

This type of chart is essentially used in scenarios where the data is broken into different categories, and when the developer needs to highlight the most important factors from a given set of factors. For example, quality control, inventory control, and customer grievance handling are some areas where Pareto chart analysis can be frequently used.

Sample Image

Description


ChartType.Pareto Represents a Pareto chart.

It is used to show the relative portion of each factor to the total or the most significant factors in the data.

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

C#

// Enable enhanced shape and chart engines.
fpSpread1.Features.EnhancedShapeEngine = true;
fpSpread1.Features.EnhancedChartEngine = true;
// Pareto chart.
object[,] dataArray ={
    {"Reason", "Cases" },
    {"Traffic", 20 },
    {"Child care",  15 },
    {"Public transportation",   13 },
    {"Weather", 6 },
    {"Overslept",   4 },
    {"Emergency",   1 }
};
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.Pareto, 100, 150, 400, 300, false);
fpSpread1.AsWorkbook().ActiveSheet.ChartObjects[0].Chart.ShowTitle();
fpSpread1.AsWorkbook().ActiveSheet.ChartObjects[0].Chart.ChartTitle.Text = "Case Report";

VB

' Enable enhanced shape and chart engines.
fpSpread1.Features.EnhancedShapeEngine = True
fpSpread1.Features.EnhancedChartEngine = True
' Pareto chart.
Dim dataArray As Object(,) = {
    {"Reason", "Cases"},
    {"Traffic", 20},
    {"Child care", 15},
    {"Public transportation", 13},
    {"Weather", 6},
    {"Overslept", 4},
    {"Emergency", 1}
}
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.Pareto, 100, 150, 400, 300, False)
fpSpread1.AsWorkbook().ActiveSheet.ChartObjects(0).Chart.ShowTitle()
fpSpread1.AsWorkbook().ActiveSheet.ChartObjects(0).Chart.ChartTitle.Text = "Case Report"