DataLabelCollection.SetVisibility(Int32, Boolean) Method

Shows or hides a data label for the specified data point.

Namespace: DevExpress.Spreadsheet.Charts

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void SetVisibility(
    int itemIndex,
    bool visible
)

VB.NET

Sub SetVisibility(
    itemIndex As Integer,
    visible As Boolean
)

Parameters

Name	Type	Description
itemIndex	Int32	The zero-based position of the target data point within the series.
visible	Boolean	true to display the label for the data point; otherwise, false.

Remarks

Use the DataLabelCollection.IsVisible method to determine whether a data label for a specific data point is displayed. The DataLabelCollection.HiddenLabels property returns the hidden label collection.

Show Individual Data Labels

The example below displays data labels for the minimum and maximum data points on the chart.

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"];

// Hide the chart's legend.
chart.Legend.Visible = false;

chart.Series[0].UseCustomDataLabels = true;
// Display the label for the third data point (minimum value).
chart.Series[0].CustomDataLabels.SetVisibility(2, true);
// Display the label for the sixth data point (maximum value).
chart.Series[0].CustomDataLabels.SetVisibility(5, true);

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")

' Hide the chart's legend.
chart.Legend.Visible = False

chart.Series(0).UseCustomDataLabels = True
' Display the label for the third data point (minimum value).
chart.Series(0).CustomDataLabels.SetVisibility(2, True)
' Display the label for the sixth data point (maximum value).
chart.Series(0).CustomDataLabels.SetVisibility(5, True)

Hide Individual Data Labels

The example below displays data labels for all data points on the chart except for the first point.

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"];

// Hide the chart's legend.
chart.Legend.Visible = false;

chart.Series[0].UseCustomDataLabels = true;
// Display data point values.
chart.Series[0].CustomDataLabels.ShowValue = true;
// Hide the first data label.
chart.Series[0].CustomDataLabels.SetVisibility(0, false);
// You can also use the Hidden property to hide the label.
//chart.Series[0].CustomDataLabels.Add(0).Hidden = true;

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")

' Hide the chart's legend.
chart.Legend.Visible = False

chart.Series(0).UseCustomDataLabels = True
' Display data point values.
chart.Series(0).CustomDataLabels.ShowValue = True
' Hide the first data label.
chart.Series(0).CustomDataLabels.SetVisibility(0, False)
' You can also use the Hidden property to hide the label.
'chart.Series[0].CustomDataLabels.Add(0).Hidden = true;