LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Excel 2007 Data Labels

I have some VBA code that was used in Excel 2003 to reposition some chart
labels. It ran fine in Excel 2003. I'm now running the same code in Excel
2007.

The macro uses the Series Collection Datalabels(index).Left in order to
calculate the position to move the label. I'm encountering some strange
behavior and wondered if anyone else ran into this. If I run the macro as
usual (F5), I get a different value returned from Datalabels(index).Left
versus if I run the macro stepping into it (F8).

In other words, I get the correct result when I step into the macro (F8)
versus running it(F5).

Hope this makes senses.
 
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
Change All Data Labels in Excel 2007 Stacked Bar Chart KMH Charts and Charting in Excel 1 January 30th 10 11:42 PM
data labels in 2007 John Charts and Charting in Excel 12 October 30th 09 11:04 AM
Excel 2007: Stacked column chart with white data labels Luca Brasi Charts and Charting in Excel 2 June 13th 09 12:26 AM
Excel 2007 text labels in category axis - missing labels Boris Charts and Charting in Excel 3 December 5th 08 04:33 PM
Excel 2007 Chart Plot #N/A Data labels Dave[_55_] Excel Programming 1 April 17th 08 09:44 PM


All times are GMT +1. The time now is 03:05 AM.

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"