ExcelBanter - 2007: .DataLabels.Position

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" wrote in message
...
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