3 Replies Latest reply: Mar 29, 2017 1:16 PM by yusuuf rawat RSS

    Mark Multiple Max values in Bar chart of each month

    yusuuf rawat

      Good day

       

      Bar chart

      Dimension 1 = Month

      Dimension 2 = Year

      Expression = Sum( Sales)

       

      There are 3 years , so for Jan there will be 3 groups Jan value 200 , 300 , 500 for 2011 , 2012 , 2014 respectively in a grouped bar chart

      For feb , 3 bars  of value 2000 , 1000 , 1200 , for 2011 , 2012 , 2013 respectively

       

      I want to change the background color for the maximum value of each month ,

      eg Highlight Maximum the bar with maximum value of the various Januarys

      Highlight the bar with Maximum value of the 3 bars for the various Febuarys

      and so forth for all months

       

      Please assist