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+

SeriesLayoutOptions.Waterfall Property

Returns options for a waterfall data series.

Namespace: DevExpress.Spreadsheet.Charts

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

Declaration

WaterfallSeriesOptions Waterfall { get; }
ReadOnly Property Waterfall As WaterfallSeriesOptions

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.

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