Spread Windows Forms 14.0
Spread Windows Forms 14.0 Product Documentation / Developer's Guide / Chart Control / Understanding Charts / Plot Types / Y Plot Types / Pareto Charts
In This Topic
    Pareto Charts
    In This Topic

    A pareto chart contains both bars and a line graph. Individual values are represented in descending order by bars and the cumulative total is represented by a line. The pareto chart is used to highlight the most important items in a set of values.

    Pareto Chart Example

    You can use the ParetoSeries class and the YPlotArea class to create a pareto chart.

    For information about creating charts in the Spread Designer or the Chart Designer, refer to Using the Chart Control on sheet or Adding a Chart Control.

    Using Code

    1. Add data for the chart with the ParetoSeries class.
    2. Specify the plot area using the YPlotArea class.
    3. Set the position and size of the plot area.
    4. Add a series to the plot area.
    5. Create a chart model and add the plot area to this model.
    6. Create a chart and set a chart model for this chart.
    7. Add the chart to SPREAD.

    Example

    This example creates a pareto chart.

    C#
    Copy Code
    fpSpread1.ActiveSheet.Cells[0, 1].Text = "Test Score";
    fpSpread1.ActiveSheet.SetClipValue(1, 0, 13, 1, "Class1\r\nClass1\r\nClass2\r\nClass2\r\nClass3\r\nClass2\r\nClass3\r\nClass2\r\nClass3\r\nClass2\r\nClass2\r\nClass3");
    fpSpread1.ActiveSheet.SetClipValue(1, 1, 13, 1, "20\r\n35\r\n40\r\n55\r\n80\r\n60\r\n61\r\n85\r\n60\r\n60\r\n64\r\n75");
    fpSpread1.ActiveSheet.AddChart(new FarPoint.Win.Spread.Model.CellRange(0, 0, 13, 2), typeof(FarPoint.Win.Chart.ParetoSeries), 400, 300, 150, 30);
    
    // Set YPlotArea
    YPlotArea YPlotArea = (YPlotArea)fpSpread1.ActiveSheet.Charts[0].Model.PlotAreas[0];
    ParetoSeries hisSeries = (ParetoSeries)YPlotArea.Series[0];
    hisSeries.ParetoLine.PointMarker = new BuiltinMarker(MarkerShape.Square, 7.0f);
    hisSeries.BinOption.BinType = FarPoint.Win.Chart.BinOption.HistogramBinType.Automatic;
    
    VB
    Copy Code
    FpSpread1.ActiveSheet.Cells(0, 1).Text = "Test Score"
    FpSpread1.ActiveSheet.SetClipValue(1, 0, 13, 1, "Class1" & vbCrLf & "Class1" & vbCrLf & "Class2" & vbCrLf & "Class2" & vbCrLf & "Class3" & vbCrLf & "Class2" & vbCrLf & "Class3" & vbCrLf & "Class2" & vbCrLf & "Class3" & vbCrLf & "Class2" & vbCrLf & "Class2" & vbCrLf & "Class3")
    FpSpread1.ActiveSheet.SetClipValue(1, 1, 13, 1, "20" & vbCrLf & "35" & vbCrLf & "40" & vbCrLf & "55" & vbCrLf & "80" & vbCrLf & "60" & vbCrLf & "61" & vbCrLf & "85" & vbCrLf & "60" & vbCrLf & "60" & vbCrLf & "64" & vbCrLf & "75")
    FpSpread1.ActiveSheet.AddChart(New FarPoint.Win.Spread.Model.CellRange(0, 0, 13, 2), GetType(FarPoint.Win.Chart.ParetoSeries), 400, 300, 150, 30)
    
    // Set YPlotArea
    Dim YPlotArea As YPlotArea = CType(FpSpread1.ActiveSheet.Charts(0).Model.PlotAreas(0), YPlotArea)
    Dim hisSeries As ParetoSeries = CType(YPlotArea.Series(0), ParetoSeries)
    hisSeries.ParetoLine.PointMarker = New BuiltinMarker(MarkerShape.Square, 7.0F)
    hisSeries.BinOption.BinType = FarPoint.Win.Chart.BinOption.HistogramBinType.Automatic