Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007: .top property not working with datalabels | Excel Programming | |||
Chart Datalabels.Position | Excel Programming | |||
Error 1004 when programming DataLabels.Position | Excel Programming | |||
Lock the chart but leave datalabels position editable | Charts and Charting in Excel | |||
Be able to edit position of datalabels in a protected chart. | Excel Programming |