How to set the DataLabel position for chart series using XlsIO?

1 min read

The position of datalabels of a chart series can be changed using XlsIO. There are a number of options available that will allow you to place the datalabel relative to the data series position. The following code illustrates this:

IChartSerie serieOne = chart.Series[0];
serieOne.DataPoints.DefaultDataPoint.DataLabels.Position = ExcelDataLabelPosition.Center;
serieOne.DataPoints.DefaultDataPoint.DataLabels.IsCategoryName = true;

Dim serieOne As IChartSerie = chart.Series(0)
serieOne.DataPoints.DefaultDataPoint.DataLabels.Position = ExcelDataLabelPosition.Center
serieOne.DataPoints.DefaultDataPoint.DataLabels.IsCategoryName = True

Here is the sample for your reference:

Chart_DataLabel_Position.zip

Did you find this information helpful?

Yes

Comments (0)

How to set the DataLabel position for chart series using XlsIO?

Access denied