If you programmatically

- set the .DataLabels.Position to (for example) xlLabelPositionRight
- change the .top and .left of some of the labels
- set again the .DataLabels.Position to (for example) xlLabelPositionRight

for position of the labels is not reset to xlLabelPositionRight

This used to be the case with previous versions

MrT

What I found was somewhat different:

1. The first label to be moved to a different .Top or .Left position caused
that line to fail. It is as if the chart didn't yet realize that the data
label existed, and DoEvents did not help. With the offending line
highlighted, using F5 to resume the code let it run to completion. Stepping
through using F8 never failed the .Top or .Left line of code.

2. The labels were reset to xlLabelPositionRight. You had to select a chart
element (manually or programmatically) before you could see the final
configuration, perhaps because a redraw was required, but DoEvents wasn't
sufficient. I didn't yet try with ScreenUpdating off and on again.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"MrT" <(E-Mail Removed)> wrote in message
news:8F7627DA-832A-45B7-8F45-(E-Mail Removed)...
> If you programmatically
>
> - set the .DataLabels.Position to (for example) xlLabelPositionRight
> - change the .top and .left of some of the labels
> - set again the .DataLabels.Position to (for example) xlLabelPositionRight
>
> for position of the labels is not reset to xlLabelPositionRight
>
> This used to be the case with previous versions
>
> MrT