Title changes when a datalabel is suppose to change?

[Joachimjr]

Hello everyone,

This is done with the macro recorder:

Please Login or Register  to view this content.

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?

[Andy Pope]

try

Please Login or Register  to view this content.

[Joachimjr]

Worked out great Andy, thanks a lot!