DataLabelCollection.HiddenLabels Property

Returns the collection of hidden labels.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v23.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

IEnumerable<int> HiddenLabels { get; }

VB.NET

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:

• DataLabelCollection.SetVisibility;

• DataLabel.Hidden.

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

C#

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

VB.NET

' Create a chart and specify its location.
Dim chart As 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.
Dim hiddenLabels As IEnumerable(Of Integer) = chart.Series(0).CustomDataLabels.HiddenLabels
For Each index As Integer In hiddenLabels
    chart.Series(0).CustomDataLabels.FindByIndex(index).Hidden = False
Next index