How do I retrieve main title and ordinate axis title?

[hill0093]

In my XYChart macro in Excel 2003, how do I retrieve the main title and the ordinate axis title?

 

[John_w]

By using the Macro Recorder, I got:

Sub xy()
    With ActiveSheet.ChartObjects(1).Chart
        Debug.Print .ChartTitle.Characters.Text
        Debug.Print .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text
        Debug.Print .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text
    End With
End Sub

 

[hill0093]

Thanks