2 Replies Latest reply on Jun 21, 2016 7:53 PM by Aman Chauhan

    Reference Line for Average

    Aman Chauhan

      Hi All,

       

      I have a data in the following format-

       

          

      ClientGood Or Bad             Year
      AGood2016
      BBad2016
      CGood2016
      DGood2016
      EGood2016
      FBad2015
      GGood2014
      HBad2015
      IGood2014
      JGood2013
      KGood2016
      LGood2015

       

      and with this data I got a bar chart like the one attached-

       

      In this chart I want a reference line which shows the average of "Good" clients over the 4 year period.

      In this case it will be 2.25 as there are 9 Good Clients over the 4 Year period.

      So I need a line just above the "Number or Records = 2" mark

      Can someone please help