Position DataLabels

Aspose.Cells Product Family
1

Hi.


I have to position datalabels in my chart in above type.
I use the Aspose.Cells version 4.8.1.0 and this istruction don’t work.

ASeries seriesx_share = o_chart.NSeries[X];
seriesx_share.Name = “=‘DataSheet’!A” + (X + 2).ToString();
seriesx_share.Values = “=‘DataSheet’!B” + (X+2).ToString() + “:” + mycells[(wSheet.Cells.MaxColumn)] + (X+2).ToString();
seriesx_share.Line.IsVisible = true;
seriesx_share.DataLabels.IsValueShown = true;
seriesx_share.DataLabels.TextFont.Size = 8;
seriesx_share.DataLabels.TextFont.Name = “Calibri”;
seriesx_share.DataLabels.Postion = LabelPositionType.Above;
2

Hi,

Please try the latest version:
Aspose.Cells
for .NET v7.1.0.4
and let us know your feedback.

If the problem persists, then provide us your sample source and output xls/xlsx file which you can create manually using Ms-Excel and the complete sample code you are using.

3

I don’t use the latest version because I generate more report in my project and I convert more file.

Is there a solution for release 4.8.1.0?

Thank you
4

Hi,

Please refer to this post and see if it is useful for you.
https://forum.aspose.com/t/123652

5

I apply one workaround, set the property X and Y of the DataLabels.

Thank you
6

Hi,

It’s good to know your problem is finally resolved.

Please feel free to ask any other question, we will help you asap.