topic Change expression axis labels font color using macro in QlikView

Change expression axis labels font color using macro

Tue, 26 Aug 2014 05:34:55 GMT

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

Tue, 26 Aug 2014 06:16:51 GMT

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