Colored Labels on top of Column Chart Bars

[Fabian.jaenicke]

Hello,
I’m generating the following column chart via spire.xls.
Now I’m looking for a way to make the background of the labels on top of the columns (As marked in the attached screenshot) with white background.
So that they don't interfere with the horizontal lines anymore.
In your guides I only find an example with line charts, which doesn’t seem to work for this kind of chart.

I’m Looking forward to your answer.

[Brian.Li]

Hello,

Thanks for your inquiry.
Please refer to following code to meet your needs.

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"test.xlsx");

            Chart chart = workbook.Worksheets[0].Charts[0];

            foreach (ChartSerie chartSerie in chart.Series)
            {
                chartSerie.DataLabels.FrameFormat.Fill.ForeColor = Color.White;
            }
            workbook.SaveToFile("result.xlsx", ExcelVersion.Version2016);

If this is not what you want, please provide your input file and your desired output for further investigation. You can upload them here or send them to us (support@e-iceblue.com) via email. Thanks in advance.

Sincerely,
Brian
E-iceblue support team

[Brian.Li]

Hello,

Greetings from E-iceblue!
Did the code we provided work for you? Any feedback will be greatly appreciated.

Sincerely,
Brian
E-iceblue support team