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)

 

[Andy Pope]

Hi,

Try this with an active chart,

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

Apparently does not work in xl2007.

Cheers
Andy