Hello all.
Is there a way to set the label background colour on a straight table with the horizontal setting selected in the chart's presentation tab?
I have tried using the Custom Format Cell function but can only get this to work for a pivot table.
In the attached example I have 3 charts:
Sales - Pivot Table: The blue and red label background colours are correct.
Sales - Straight Table: The blue and red label background colours are set using Custom Format Cell, however, they do not show on the chart.
Sales - Straight Table - Horizontal: Cannot set the lable background colour for the first expression (ie. North America). Can set the label background colour for
the fifth expression (ie. Europe), however, it does not show on the chart.
The chart I need is the horizontal version.
I am using QlikView 10 SR2.
Thanks,
John.