Formatting data labels in Excel charts using VBA

2019-08-12 00:56发布

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

1条回答
看我几分像从前
2楼-- · 2019-08-12 01:33
ActiveChart.SeriesCollection(1).DataLabels.NumberFormat = "0.00%"
查看更多
登录 后发表回答