All docs
V20.2
20.2
20.1
The page you are viewing does not exist in version 20.1. This link will take you to the root page.
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

SubtotalDataPointCollection Interface

A collection of data points that are displayed as totals in a waterfall chart.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll

Declaration

public interface SubtotalDataPointCollection :
    ISimpleCollection<int>,
    IEnumerable<int>,
    IEnumerable,
    ICollection
Public Interface SubtotalDataPointCollection
    Inherits ISimpleCollection(Of Integer),
             IEnumerable(Of Integer),
             IEnumerable,
             ICollection

Remarks

If the source data for a waterfall chart includes subtotal and total values, you can display these values as total columns. These columns start on the horizontal axis at zero and do not float. Use the Series.LayoutOptions.Waterfall.SubtotalDataPoints.Add method to add the required data points to the total point collection.

The example below creates a waterfall chart. The third and last data points are displayed as totals.

// Create a waterfall chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.Waterfall, worksheet["B2:C7"]);
chart.TopLeftCell = worksheet.Cells["E2"];
chart.BottomRightCell = worksheet.Cells["L17"];

// Hide the major gridlines for the value axis.
chart.PrimaryAxes[1].MajorGridlines.Visible = false;

// Specify series options.
var options = chart.Series[0].LayoutOptions.Waterfall;
// Display connector lines.
options.ShowConnectorLines = true;
// Set the third data point as the total.
options.SubtotalDataPoints.Add(2);
// Set the last data point as the total.
options.SubtotalDataPoints.Add(5);

// Add the chart title.
chart.Title.Visible = true;
chart.Title.SetValue("Income Statement");
See Also