Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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