Obtain the data source Axis Title

[Gilles P (FR)]

Hello,

With standard interactive ExcelGraph, I create a title of axis wich is the
cell value of a worksheet
by a formula "=Sheet1!R1C1"
To obtain an axe title linked with the cell value

How with VBA can i read this formula ?
the property "Axes(xlValue, xlPrimary).AxisTitle.Text " give the value of
R1C1 and not the formula ?

Thanks

Gilles PROVOST (FR)

 

[Dave D-C]

I haven't tried this, but how about
Dim s1$, sFormula$
s1 = Axes(xlValue, xlPrimary).AxisTitle.Text
sFormula = Range(s1).Formula
Dave D-C

 

[Gilles P (FR)]

Sorry but,
That's doesn't work

S1 return the value (and not the formula)
And so Range(S1).formula gives an error by "property method error"

regards,

Gilles P (FR)

 

[Andy Pope]

Hi,

Try this with an active chart,

msgbox ExecuteExcel4Macro("GET.FORMULA(""Title"")")

Apparently does not work in xl2007.

Cheers
Andy