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

    A waterfall chart can be used to show how an initial value is affected by negative or positive values. Columns are color coded so you can quickly see differences between positive and negative values. Some values start on the horizontal axis, while intermediate values are shown as floating columns.

    Waterfall Chart Example

    You can use the WaterfallSeries class and the YPlotArea class to create a waterfall chart.

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

    Using Code

    1. Create the series with the WaterfallSeries class.
    2. Create the plot type.
    3. Set properties for the class.
    4. Add the chart.

    Example

    This example creates a waterfall chart.

    C#
    Copy Code
    FarPoint.Win.Chart.WaterfallSeries wseries = new FarPoint.Win.Chart.WaterfallSeries();
    wseries.SeriesName = "Series0";
    wseries.Values.Add(10);
    wseries.Values.Add(-5);
    wseries.Values.Add(-1);
    wseries.Values.Add(4);
    wseries.Border = new FarPoint.Win.Chart.SolidLine(Color.Black);
       
    FarPoint.Win.Chart.YPlotArea plotArea = new FarPoint.Win.Chart.YPlotArea();
    plotArea.Location = new System.Drawing.PointF(0.2f, 0.2f);
    plotArea.Size = new System.Drawing.SizeF(0.6f, 0.6f);
    plotArea.Series.Add(wseries);
    FarPoint.Win.Chart.ChartModel model = new FarPoint.Win.Chart.ChartModel();
    model.PlotAreas.Add(plotArea);

    FarPoint.Win.Spread.Chart.SpreadChart chart = new FarPoint.Win.Spread.Chart.SpreadChart();
    chart.Model = model;
    chart.Size = new Size(200, 200);
    chart.Location = new Point(100, 100);
    fpSpread1.Sheets[0].Charts.Add(chart);
    VB
    Copy Code
    Dim wseries = New FarPoint.Win.Chart.WaterfallSeries()
    wseries.SeriesName = "Series0"
    wseries.Values.Add(10)
    wseries.Values.Add(-5)
    wseries.Values.Add(-1)
    wseries.Values.Add(4)
    wseries.Border = New FarPoint.Win.Chart.SolidLine(Color.Black)    
    Dim plotArea As New FarPoint.Win.Chart.YPlotArea()
    plotArea.Location = New System.Drawing.PointF(0.2F, 0.2F)
    plotArea.Size = New System.Drawing.SizeF(0.6F, 0.6F)
    plotArea.Series.Add(wseries)
    Dim model As New FarPoint.Win.Chart.ChartModel()
    model.PlotAreas.Add(plotArea)

    Dim chart As New FarPoint.Win.Spread.Chart.SpreadChart()
    chart.Model = model
    chart.Size = New Size(200, 200)
    chart.Location = New Point(100, 100)
    fpSpread1.Sheets(0).Charts.Add(chart)