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+

DataLabelCollection.HiddenLabels Property

Returns the collection of hidden labels.

Namespace: DevExpress.Spreadsheet.Charts

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

Declaration

IEnumerable<int> HiddenLabels { get; }
ReadOnly Property HiddenLabels As IEnumerable(Of Integer)

Property Value

Type Description
IEnumerable<Int32>

An enumerator that supports iteration over the collection.

Remarks

You can use the following API to hide individual data labels on a chart:

The following example iterates through the HiddenLabels collection and displays all hidden labels:

// Create a chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet["B2:C8"]);
chart.TopLeftCell = worksheet.Cells["F2"];
chart.BottomRightCell = worksheet.Cells["L15"];

chart.Series[0].UseCustomDataLabels = true;
// Display all data point values.
chart.Series[0].CustomDataLabels.ShowValue = true;
// Hide individual data labels.
chart.Series[0].CustomDataLabels.SetVisibility(0, false);
chart.Series[0].CustomDataLabels.SetVisibility(1, false);

// Iterate through the collection
// and display all hidden labels.
var hiddenLabels = chart.Series[0].CustomDataLabels.HiddenLabels;
foreach (int index in hiddenLabels)
    chart.Series[0].CustomDataLabels.FindByIndex(index).Hidden = false;
See Also