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!


      Best,

       

       

      Lashaw Salta