Skip to main content
All docs
V24.2

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SeriesLayoutOptions.Waterfall Property

Returns options for a waterfall data series.

Namespace: DevExpress.Spreadsheet.Charts

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

WaterfallSeriesOptions Waterfall { get; }

#Property Value

Type Description
WaterfallSeriesOptions

An object that stores series options for waterfall charts.

#Property Paths

You can access this nested property as listed below:

Object Type Path to Waterfall
Series
.LayoutOptions .Waterfall

#Remarks

Use the WaterfallSeriesOptions object’s properties to specify options for a waterfall chart.

Property Description
WaterfallSeriesOptions.ShowConnectorLines Specifies whether to display connector lines between data points.
WaterfallSeriesOptions.SubtotalDataPoints Returns a collection of total points.

Waterfall chart

// 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