0 Replies Latest reply: Mar 26, 2012 6:49 PM by Graham Crooks RSS

    Change orientation of x-axis labels based on selection in cyclic group?

    Graham Crooks

      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.

      Regards

      Graham