6 Replies Latest reply: Aug 14, 2012 11:27 AM by thomas.whitaker RSS

    Keeping comparable data in bar chart

      I have the following data that I have turned into a bar chart (Dimension=Product and Expression=Average Markup). I then have a list box for the country so that the graph is dynamic.

       

      What I would like to do is design the bar chart so that the UK bars alway remaim on the chart as a comparitor and can be seen behind the selected country from the list box (in this case Spain or Ukraine)

       

       

      CountryProductAverage Markup
      UKA£0.20
      UKB£0.40
      UKC£0.60
      UKD£0.10
      SpainA£0.80
      SpainB£0.50
      SpainC£0.30
      SpainD£0.25
      PolandA£1.00
      PolandB£1.20
      PolandC£0.50
      PolandD£0.35

       

      I suspect this means adding a new expression with a bit of set analysis but I am stuck, any help much appreciated.

       

      T