I want to link a large excel spreadsheet with graphs into powerpoint. I want the graphs to update automatically to the next month and drop the previous. I am also looking to learn how I can include 2 seperate data ranges (axis to show month) in the source date.
I currently go into the graph and change the source data but after 300 charts it becomes very tedious.
