Set offset by X and Y for actual values of Data Labels

Aspose.Cells Product Family
,
1

Hello, I’m currently using Aspose Words and Aspose Cells for .NET 24.2.0.
I cant set the X and Y offsets for the actual data label values using Aspose Words and Aspose Cells.
I need to set offset X to the left by 15 points and offset Y up by 30 points.
What settings for series data labels need to be set for the data labels to move? I am attaching a screenshot of the actual example_1.PNG (13.4 KB) and expected example_2.PNG (13.5 KB) result.

2

@DelyaKh
Thank you for providing the screenshot.

For Aspose.Cells,could you please zip and attach your sample files, including the input Excel file (if any), the current output Excel file generated by Aspose.Cells, and the expected output Excel file that you may create manually in MS Excel? Also, please share the sample (runnable) code that you are using. We will review your issue soon.

For Aspose.Words,please raise your question here.

3

@DelyaKh,

I evaluated your requirements further. See the following sample code segment for your reference. You may refer to it and write/update your own code accordingly.

......
//Get the first series in the chart.
Series series = chart.NSeries[0];
//You need to move DataLabels a little rightward or downwards
chart.Calculate();
int XDELTA = 15;
int YDELTA = 10;
for (int i = 0; i < series.Points.Count; i++)
{

    int X = series.Points[i].DataLabels.X;
    int Y = series.Points[i].DataLabels.Y;
    series.Points[i].DataLabels.X = X + XDELTA;
    series.Points[i].DataLabels.Y = Y + YDELTA;

}
.....

Hope, this helps a bit.