officefileapi-devexpress-dot-spreadsheet-dot-charts-dot-boxandwhiskerseriesoptions-48edb288.md
Specifies whether to show outlier data points that lie either below the lower whisker line or above the upper whisker line.
Namespace : DevExpress.Spreadsheet.Charts
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
bool ShowOutlierPoints { get; set; }
Property ShowOutlierPoints As Boolean
| Type | Description |
|---|---|
| Boolean |
true to display the outlier points; otherwise, false.
|
You can access this nested property as listed below:
| Object Type | Path to ShowOutlierPoints |
|---|---|
| SeriesLayoutOptions |
.BoxAndWhisker .ShowOutlierPoints
|
The example below demonstrates how to create a box and whisker chart and specify its options.
// Create a box and whisker chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.BoxAndWhisker, worksheet["B2:E17"]);
chart.TopLeftCell = worksheet.Cells["G2"];
chart.BottomRightCell = worksheet.Cells["N17"];
// Set the minimum and maximum values for the value axis.
Axis axis = chart.PrimaryAxes[1];
axis.Scaling.AutoMax = false;
axis.Scaling.Max = 70;
axis.Scaling.AutoMin = false;
axis.Scaling.Min = 40;
// Specify series options.
foreach (Series series in chart.Series)
{
var options = series.LayoutOptions.BoxAndWhisker;
options.ShowInnerPoints = true;
options.ShowMeanLine = false;
options.ShowOutlierPoints = true;
options.ShowMeanMarkers = true;
options.QuartileCalculationMethod = QuartileCalculationMethod.ExclusiveMedian;
}
// Add the chart title.
chart.Title.Visible = true;
chart.Title.SetValue("Academic Performance Distribution");
' Create a box and whisker chart and specify its location.
Dim chart As Chart = worksheet.Charts.Add(ChartType.BoxAndWhisker, worksheet("B2:E17"))
chart.TopLeftCell = worksheet.Cells("G2")
chart.BottomRightCell = worksheet.Cells("N17")
' Set the minimum and maximum values for the value axis.
Dim axis As Axis = chart.PrimaryAxes(1)
axis.Scaling.AutoMax = False
axis.Scaling.Max = 70
axis.Scaling.AutoMin = False
axis.Scaling.Min = 40
' Specify series options.
For Each series As Series In chart.Series
Dim options As BoxAndWhiskerSeriesOptions = series.LayoutOptions.BoxAndWhisker
options.ShowInnerPoints = True
options.ShowMeanLine = False
options.ShowOutlierPoints = True
options.ShowMeanMarkers = True
options.QuartileCalculationMethod = QuartileCalculationMethod.ExclusiveMedian
Next series
' Add the chart title.
chart.Title.Visible = True
chart.Title.SetValue("Academic Performance Distribution")
See Also
BoxAndWhiskerSeriesOptions Interface