Formatting data labels in Excel charts using VBA

Question

I would like to change the data labels for the picture below from decimals (0.8102), like that of the blue part, to percentage (81.02%), like the red part of the stacked chart.

I have tried recording a macro but it does not show any code for the formatting of data labels.

enter image description here

May you teach me how you can make it appear like that?

IlhamideaZ
– IlhamideaZ

2015-11-16 01:24:11 +00:00
Commented Nov 16, 2015 at 1:24 — IlhamideaZ
– IlhamideaZ, Commented Nov 16, 2015 at 1:24

Jean-François Corbett · Accepted Answer · 2014-01-20 11:39:27Z

3

ActiveChart.SeriesCollection(1).DataLabels.NumberFormat = "0.00%"

answered Jan 20, 2014 at 11:39

Jean-François Corbett

38.7k30 gold badges144 silver badges192 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Formatting data labels in Excel charts using VBA

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related