Hello everyone,
This is done with the macro recorder:
Sub Macro2()
ActiveSheet.ChartObjects("Chart 10").Activate
ActiveChart.FullSeriesCollection(1).DataLabels.Select
ActiveChart.FullSeriesCollection(1).Points(4).DataLabel.Select
Selection.Left = 0
Selection.Top = 120.65
End Sub
When I change this code to affect my activechart (not "Chart10") and add it to my full code, it alters the chart title when the macro is used on a clustered column chart and it alters the position of the actual chart when it's used on a Pie Chart. Why doesn't it change datalabel4 when it clearly states that it's the fullseriescollection that should be targeted?
Bookmarks