Change expression axis labels font color using macro

[#1]

Hi,

Can anyone help me set the font color of expression axis label using macro.

The path is Chart -> Properties -> Axes -> Expression Axes -> Font, I want to change the colour in this window using a macro.

Thanks,

Jyotsna

[#2 · Accepted solution]

I found it , here it is in case someone needs it

Set gp = Chart.GetProperties

Set cp = gp.ChartProperties

gp.Expressions.Item(0).Item(0).Data.AxisData.TextColor.PrimaryCol.Col = RGB(255,255,255)

Thanks,

Jyotsna