0 Replies Latest reply: May 8, 2013 12:22 PM by Michael Todd RSS

    Staggering labels on chart

    Michael Todd

      Hi,

      I have a line chart that shows an expression over weekly values.  There are many values for the "week" dimension value, so I don't want to show all of these on the x axis as it will look cluttered.  Ideally I only want to show a few - perhaps the first, last and two inbetween.  I know you can use the 'stagger labels' function but this does every other value and is not quite what I want.

       

      I have been trying to achieve this by creating a rank of the week number and then use this to conditional set the font colour of the axis label e.g. set rank 1, 5 and 8 to black and the rest to white (using a chart with a white background).  Therefore this would hide all but 3 labels.  However, haven't managed to get it to work as yet.  The advantage to this approach (if I can get it working) is that it will keep the gridlines (you lose them if the dimension label is not shown).

       

      Any ideas most welcome.

       

      Ta,

      Mike.