excel - How to set pie chart label format as a cellformat programmatically in VBA -

excel - How to set pie chart label format as a cellformat programmatically in VBA -

i'm generating pie chart set of data.

the chart labels have value , percentage. i want format value 1 in cell using vba

i don't know start.....

you can link number format of labels number format of cell. via ui you'd formatting labels , on number tab select "link source".

if run macro recorder during that, respective vba, i.e. link

activechart.seriescollection(1).datalabels.numberformatlinked = -1

and unlink

activechart.seriescollection(1).datalabels.numberformatlinked = 0

excel excel-vba