WaterfallSeries.SubtotalDataPoints Property

Gets or sets the collection of subtotal points for the waterfall series.

Namespace: DevExpress.Docs.Office

Assembly: DevExpress.Docs.Core.v26.1.dll

NuGet Package: DevExpress.Docs.Core

Declaration

C#

public SubtotalDataPointCollection SubtotalDataPoints { get; set; }

VB.NET

Public Property SubtotalDataPoints As SubtotalDataPointCollection

Property Value

Type	Description
SubtotalDataPointCollection	A SubtotalDataPointCollection object.

Remarks

The following code snippet marks the second and fourth points in the series as subtotal points:

C#

using DevExpress.Docs.Office;
using DevExpress.Docs.Presentation;

ChartEx chart = new ChartEx();
slide.Shapes.Add(chart);
chart.Width = presentation.SlideSize.Width;
chart.Height = presentation.SlideSize.Height;

WaterfallSeries waterfallSeries = new WaterfallSeries();
waterfallSeries.Text = "Cash Flow";
waterfallSeries.Arguments = new ChartStringData(new[] { "Start", "Jan", "Feb", "Mar", "End" });
waterfallSeries.Values = new ChartNumericData(new[] { 10.0, 12.0, -5.0, 8.0, 15.0 });

// Mark the second and fourth points as subtotal points.
waterfallSeries.SubtotalDataPoints.Add(1);
waterfallSeries.SubtotalDataPoints.Add(3);

chart.Series.Add(waterfallSeries);

VB.NET

Imports DevExpress.Docs.Office
Imports DevExpress.Docs.Presentation

Dim chart As New ChartEx()
slide.Shapes.Add(chart)
chart.Width = presentation.SlideSize.Width
chart.Height = presentation.SlideSize.Height

Dim waterfallSeries As New WaterfallSeries()
waterfallSeries.Text = "Cash Flow"
waterfallSeries.Arguments = New ChartStringData(New String() {"Start", "Jan", "Feb", "Mar", "End"})
waterfallSeries.Values = New ChartNumericData(New Double() {10.0, 12.0, -5.0, 8.0, 15.0})

' Mark the second and fourth points as subtotal points.
waterfallSeries.SubtotalDataPoints.Add(1)
waterfallSeries.SubtotalDataPoints.Add(3)

chart.Series.Add(waterfallSeries)