Thank you for using Syncfusion products.
Currently XlsIO have no support in “Formatting Data Labels in Pivot Chart”. We would like to inform you that we have logged this as a feature request in our database. We will implement this feature in any of our upcoming releases. We usually have an interval of at least three months between releases. The feature implementation would also greatly depend on the factors such as product design, code compatibility and complexity. Please log on to our support website to check for further updates:
Mathu Mohan V A
I'm trying to do the same thing in Blazor.
Is this feature available now?
We do not have direct support for this but can be achieved through a simple workaround.
When pivot chart is created with pivot table as data source, Syncfusion XlsIO cannot create the series because the range of the pivot table is different from normal worksheet range. This is the limitation of XlsIO. To use any chart series formatting, the series should be added manually.
Please use the below code snippet to add data labels for pivot chart series.
IChartSerie serie = pivotChart.Series;
//Set data labels color
serie.DataPoints.DefaultDataPoint.DataLabels.Color = ExcelKnownColors.Blue;
serie.DataPoints.DefaultDataPoint.DataLabels.IsValue = true;
serie.DataPoints.DefaultDataPoint.DataLabels.Position = ExcelDataLabelPosition.OutsideBase;