Automate Management Report Generation - Excel to PPT for Graphs and Financial Analysis

I want to be able to export financial data (i.e. Income statement, balance sheet, prior year financials, prior month financials, year to date, production volume data, labour hours data etc) into excel and have it auto generate certain pre-defined graphs. Then I would like this spreadsheet linked to a Powerpoint template, which can simply be updated to reflect the updated financials. This is pretty straightforward, and I actually already do this, but it requires a lot of wasted time modifying cells which could be easily auto populated if I were to setup the spreadsheet correctly with a master data tab that I export the data to. The part I would need expertise on is: Allowing me to use multiple pre-defined graphs or even power point templates via an drop down in excel. I.e. Be able to input all the raw data from an export into the spread sheet, but be able to select how I want to see the data, and have a different graph show depending on what i selected. i.e. Revenue - Be able to show bar graph with CURRENT MONTH, PRIOR MONTH, PRIOR YEAR MONTH, QUARTER, YTD OR maybe next month I only want to see the revenue graph with CURRENT MONTH, PRIOR MONTH and 2 MONTHS PRIOR on one chart. The point is I do not want to have to select the data range and modify the graph every time I want to see different data represented. This is probably a lot more complex. The key to all of this, is that I want it to be flexible enough that I can input ANY company's financials into the spreadsheet and have it generate graphs and the power point. Then I can make minor changes in the power point as far as what slides I want to include.