11 Replies Latest reply on May 11, 2018 12:16 PM by Shinichiro Murakami

    Grand Total Avg of Column to a Bar Graph by Month

    Lashaw Salta

      Hi Guys,


      I'm stuck on trying to get the average cost per loan number to show up in my bar graph.


      On Sheet 1:

      Cost per loan (3rd column ) the GRAND TOTAL AVG = $2,290.86 for all 5 employees.


      On Sheet 2:

      Each bar for each month this year should represent the following totals. These totals are the average cost per loan each month.


      January: $5,796.68

      February: $3,154.20

      March: $3,060.86

      April $2,290.86


      I'm trying the LOD calc but still not getting the right numbers


      Please help!




      Lashaw Salta