LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 29
Default Retrieving linked label formula with VBA

Dear group,

I linked datalabels of a chart with cells (by selecting a single label,
typing "=", clicking the cell to link with and then enter).
Now I want to get the label's formula with VBA, but I only get the value
with objPoint.DataLabel.Text.
I am missing something like objPoint.DataLabel.Formula.
Currently I use XL 2003.
Any good ideas?

Thanks in advance, Holger.


 
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
Autofit row height when retrieving text via formula andy62 Excel Discussion (Misc queries) 3 May 4th 08 01:46 AM
How to rezize data label box in pie charts (label wraps to two lin rolliedogg Charts and Charting in Excel 1 October 18th 06 08:17 PM
Where is a sample formula for retrieving the system date? Artemis Excel Discussion (Misc queries) 3 January 31st 06 02:18 AM
Using Name Label to try to define linked cell John Links and Linking in Excel 5 December 4th 04 09:12 AM
Formula looks like a label swedbera Excel Worksheet Functions 3 November 10th 04 06:44 PM


All times are GMT +1. The time now is 11:42 AM.

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

About Us

"It's about Microsoft Excel"