Label expression works on the series groups, but n

Question

In the chart I am building the series and categories labels need to be converted before displaying. Conversion is trivial - replacing some charater with another and taking left X characters. Entered into the properties of the Series groups/General/Label the expression works fine. The legend shows the converted series names. I expected that the same should be true for the categories groups and the converted labels should show along the X axis. But that is not working - the X axis labels are still raw column names from the underlying matrix where the chart takes data from. The exact same expression is used on the matrix's column names and that works fine.

=Left(Fields!fiscalmonth.Value, 3)

That converts my November to Nov etc in the matrix, but not on the chart axis X.

Answer 1

The correct place for changing X axis labels is the Series Properties/Category Field expression. This is somewhat counter-intuitive, but works.