View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Holger Gerths Holger Gerths is offline
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.