Automate 360 degree report with Excel Data -- 2

Problem statement: We are using a tool called Survey Monkey to do 360 degree leadership survey for managers. The report that is generated in the form of PPT is inadequate. What's needed: Use the Excel data, create charts and supplement the report in the PPT. After this you need to create a PDF and mail out the report. This process has to be automated. For a more detailed brief see attached note.