excel - Q: VBA - Format Multiple Chart Data Labels At Once? -

i wondering if can me create macro edit data labels of multiple charts @ same time.

i have 9 charts on single sheet need have data labels set format "inside end". every time change data set need click on each individual chart , manually press format inside end. seeing there 200+ data sets, becomes cumbersome. there macro can this?

i'm not sure 'inside end' means, should able turn on macro records, click through usual steps, , stop recorder. have code need make changes described. now, iterate through each chart object , make necessary changes.

sub loopthroughcharts() 'purpose: loop through every graph in active workbook 'source: www.thespreadsheetguru.com/the-code-vault  dim sht worksheet dim currentsheet worksheet dim cht chartobject  application.screenupdating = false application.enableevents = false  set currentsheet = activesheet  each sht in activeworkbook.worksheets   each cht in sht.chartobjects     cht.activate      'do chart...    next cht next sht  currentsheet.activate application.enableevents = true  end sub