Show decimal values in chart columns

[markfarrer]

Hi, I have a Column3DStacked chart, how do I show the values in the data label above or inside the columns.

Regards

Mark

[Nina.Tang]

Dear markfarrer ,

Thanks for your inquiry. Here are the codes for your reference.

Code: Select all

Presentation ppt = new Presentation();
            ppt.LoadFromFile(@"C:\Users\Administrator\Desktop\Test.pptx");
            IChart chart = ppt.Slides[0].Shapes[0] as IChart;
            ChartSeriesFormatCollection sers = chart.Series;
           
                for (int i = 0; i < sers.Count; i++)
                {
                    for (int j = 0; j < sers[i].Values.Count;j++ )
                    {
                        ChartDataLabel cd = sers[i].DataLabels.Add();
                        cd.LabelValueVisible = true;
                    }
                }

            ppt.SaveToFile("Result.pptx", FileFormat.Pptx2010);

Sincerely,
Nina
E-iceblue support team

[markfarrer]

Hi Nina

thank you, that work in a manner, however it also puts the category axis names in the data label with the value, I just need the value. I have attached some files to show you what I mean.

Regards

Mark

[Nina.Tang]

Dear markfarrer ,

Try to add the code

Code: Select all

cd.CategoryNameVisible = false;

Sincerely,
Nina
E-iceblue support team

[markfarrer]

Hi Nina

no, that didn't work, but after some playing around I found the answer by adding this property to my chart

chart.Series[0].DataLabels.LabelValueVisible = true;

Regards

Mark

[Nina.Tang]

Dear markfarrer ,

I am glad that your issue is resolved. If you have any questions, welcome to contact us.

Sincerely,
Nina
E-iceblue support team