Code to change YAxis font size on a grid chart

[m_woolf]

I have a grid chart and need to change the YAxis font size by macro.

I have tried:

set rep = ActiveDocument.GetSheetObject("CH15")

set p = rep.GetProperties

     p.Expressions.Item(0).Item(0).Data.AxisData.Font.PointSize1000 = 4000

and    

     p.ChartProperties.XAxis.Font.PointSize1000 = 4000

Any ideas?

[m_woolf · Accepted solution]

I found the answer:

     p.ChartProperties.GridSecondaryAxis.Font.PointSize1000 = 4000