向图表系列的数据点添加自定义标签

您可以向图表系列的数据点添加自定义标签。Aspose.Cells提供了ChartPoint.DataLabels.Text属性以添加这些自定义标签。本文将解释如何使用此属性向图表系列的数据点添加自定义标签。

以下代码创建了通过线连接的数据标记散点图，然后在图表的系列中为数据点添加了自定义标签。每个自定义标签显示系列名称和点名称。您可以使用任何其他文本代替它。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

Workbook workbook = new Workbook(FileFormatType.Xlsx);
Worksheet sheet = workbook.Worksheets[0];

// Put data
sheet.Cells[0, 0].PutValue(1);
sheet.Cells[0, 1].PutValue(2);
sheet.Cells[0, 2].PutValue(3);

sheet.Cells[1, 0].PutValue(4);
sheet.Cells[1, 1].PutValue(5);
sheet.Cells[1, 2].PutValue(6);

sheet.Cells[2, 0].PutValue(7);
sheet.Cells[2, 1].PutValue(8);
sheet.Cells[2, 2].PutValue(9);

// Generate the chart
int chartIndex = sheet.Charts.Add(Aspose.Cells.Charts.ChartType.ScatterConnectedByLinesWithDataMarker, 5, 1, 24, 10);
Chart chart = sheet.Charts[chartIndex];

chart.Title.Text = "Test";
chart.CategoryAxis.Title.Text = "X-Axis";
chart.ValueAxis.Title.Text = "Y-Axis";

chart.NSeries.CategoryData = "A1:C1";

// Insert series
chart.NSeries.Add("A2:C2", false);

Series series = chart.NSeries[0];

int pointCount = series.Points.Count;
for (int i = 0; i < pointCount; i++)
{
    ChartPoint pointIndex = series.Points[i];

    pointIndex.DataLabels.Text = "Series 1" + "\n" + "Point " + i;
}

// Insert series
chart.NSeries.Add("A3:C3", false);

series = chart.NSeries[1];

pointCount = series.Points.Count;
for (int i = 0; i < pointCount; i++)
{
    ChartPoint pointIndex = series.Points[i];

    pointIndex.DataLabels.Text = "Series 2" + "\n" + "Point " + i;
}

workbook.Save(dataDir + "output_out.xlsx", Aspose.Cells.SaveFormat.Xlsx);