How to set percentage value for stacked bar chart?

[Kinali94]

Hello,

I need to update stacked bar chart values with percentages.

Code: Select all

value = 10;
chart.ChartData[1,1].Value = value;

Please let me know.
Thanks in advance!

Thanks,
Kinali Gandhi

[rachel.lei]

Hi Kinali,

Thanks for your inquiry.
Please refer to the code snippet below. Also, you can refer to this article: Create 100% stacked bar chart in PowerPoint in C#. If there is any question, please provide your desired output for our reference.

Code: Select all

    for (int columnlabelIndx = 0; columnlabelIndx < columnlabelLength; ++columnlabelIndx)
    {
        for (int rowlabelIndex = 0; rowlabelIndex < rowlabelLength; ++rowlabelIndex)
        {
            //Add data label
            var label = chart.Series[columnlabelIndx].DataLabels.Add();
            label.LabelValueVisible = true;
            //Set number format for data label
            chart.Series[columnlabelIndx].DataLabels[rowlabelIndex].HasDataSource = false;
            chart.Series[columnlabelIndx].DataLabels[rowlabelIndex].NumberFormat = "0#\\%";
        }
    }

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hello,

Greetings from E-iceblue!
Has your issue been resolved? Could you please give us some feedback at your convenience?
Thanks in advance.

Sincerely,
Rachel
E-iceblue support team

[Kinali94]

Hello,

Thank you so much for your help!

It's working as expected, Only one issue I am facing like:
I want to update values as Negative but don't want to display negative in chart.

for ex: value should be -30% in excel chart details but It should be display like 30% in chart.

Thanks in advance!

Regards,
Kinali Gandhi

[rachel.lei]

Hi Kinali,

Please refer to the following code snippet. Feel free to contact us if you have further questions.

Code: Select all

chart.Series[c].DataLabels[r].NumberFormat = "0#\\%;0#\\%";

Sincerely,
Rachel
E-iceblue support team

[Kinali94]

Thank you for you quick response!

It's working perfect.

Thanks,
Kinali Gandhi

[rachel.lei]

Hi Kinali,

Glad to hear that!
If you encounter any issues related to our product in the future, just feel free to contact us.
Have a nice day!

Sincerely,
Rachel
E-iceblue support team