Chart data label background colors

Aspose.Cells Product Family
1

If I set a chart’s series to have a background color of red for data labels, it works:
series.DataLabels.Area.ForegroundColor = Color.Red;

all data labels for the series are red. But if I then set one label to have different color and text:

series.Points[0].DataLabels.Area.ForegroundColor = Color.Green;
series.Points[0].DataLabels.Text = “changed”;

the text changes for the label, but the background color does not. To be sure it wasn’t the palette, I tried setting the series to green and changing the first data label to red and found that didn’t work either - the whole series is green, the text changes but the label’s background is not red.

I’m saving my workbook as xlsx format. Please advise!

2

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

I tested your scenario with the attached latest version of Aspose.Cells and it works fine. Following is my sample code:

//Instantiating a Workbook object

Workbook workbook = new Workbook();

//Get First Worksheet of the Workbook

Worksheet ws = workbook.Worksheets[0];

//Set Worksheet Type

ws.Type = SheetType.Chart;

//Add new Data Sheet

Worksheet data = workbook.Worksheets.Add("Data");

Cells cells = data.Cells;

cells["A1"].PutValue("Aspose.Cells");

cells["A2"].PutValue("Aspose.Words");

cells["A3"].PutValue("Aspose.PDF");

cells["B1"].PutValue(35);

cells["B2"].PutValue(50);

cells["B3"].PutValue(15);

Charts charts = ws.Charts;

int index = charts.Add(ChartType.Pie, 5, 0, 15, 5);

Chart chart = charts[index];

chart.NSeries.Add("Data!B1:B3", true);

chart.NSeries.CategoryData = "Data!A1:A3";

chart.NSeries[0].DataLabels.IsPercentageShown = true;

chart.NSeries[0].DataLabels.Area.ForegroundColor = Color.Red;

chart.NSeries[0].Points[0].DataLabels.Area.ForegroundColor = Color.Green;

chart.NSeries[0].Points[0].DataLabels.Text = "changed";

//Save the workbook

workbook.Save("D:\\Test_Temp\\Chart.xlsx",FileFormatType.Excel2007Xlsx);

If you still face any problem with the attached latest version, please share your complete code, template and generated excel files and we will check it soon.

Thank You & Best Regards,

3

Your code did not work for me in version 4.8.0.0, but does work with the attached version. Thank You