A presentation created and maintained by someone else was recently dropped on my plate. It contained a series of graphs created in Powerpoint and data was just manually added in each sheet from another sheet.
It contained, for the most part, 2 graphs per slide and they presented well as they were created in Powerpoint. I created some dynamic graphs in Excel from the original data sheet, with dynamic ranges, but realized that I cannot get the presentation to look remotely readable if i try to have 2 graphs were slide this way. Everything bunches up and it looks a mess.
Is there a way around this? I didn't know if I could maybe have blank powerpoint graphs (templates i suppose) and vba that brought in the appropriate data into the graphs to make them dynamic.
It contained, for the most part, 2 graphs per slide and they presented well as they were created in Powerpoint. I created some dynamic graphs in Excel from the original data sheet, with dynamic ranges, but realized that I cannot get the presentation to look remotely readable if i try to have 2 graphs were slide this way. Everything bunches up and it looks a mess.
Is there a way around this? I didn't know if I could maybe have blank powerpoint graphs (templates i suppose) and vba that brought in the appropriate data into the graphs to make them dynamic.
