Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
mrt mrt is offline
external usenet poster
 
Posts: 70
Default 2007: .DataLabels.Position

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default .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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007: .top property not working with datalabels MrT Excel Programming 1 November 28th 06 01:46 AM
Chart Datalabels.Position Michael Singmin Excel Programming 4 November 12th 05 07:12 PM
Error 1004 when programming DataLabels.Position hturk Excel Programming 18 August 27th 05 04:40 AM
Lock the chart but leave datalabels position editable Joy Charts and Charting in Excel 1 June 13th 05 08:21 PM
Be able to edit position of datalabels in a protected chart. Joy Excel Programming 2 June 13th 05 08:21 PM


All times are GMT +1. The time now is 02:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"