Hi, my latest puzzle is this: I have a cyclic group comprising Financial Year Month (Apr, May...) and Week Ending (04 Apr, 11 Apr...) dates; this group is the Dimension Axis of a line chart. However, for visual purposes, I want the Financial Year label text to appear horizontally "-" and the week ending label text to appear vertically "|" on the axis as the user switches between the two. In the Axis tab, setting the Primary Dimension Label orientation is an 'either/or' choice. Can it be switched using code / macro / other, based on the current state/selection of the cyclic group? If so, does anyone know what I write please?
All help and suggestions most appreciated.