{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 倾城 Initia 的问题《Extract excel graph to powerpoint template》','https://www.manongdao.com/q-1028601.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I have an Excel sheet in which I can select a city (100 different ones) and then a graph will be generated for that city.
I would like to create a PPT with 100 different slides, one for each city. For these slides I have a template, so what I would like to achieve is: - Loop through all 100 cities - Copy the generated graph and paste as image at a specified location and size in the PPT slide
Does anyone have an idea on how to do this with either VBA or Python?
Many thanks!
To copy and paste an excel range into powerpoint using VBA check this link : Copy & Paste An Excel Range Into PowerPoint With VBA
Hope it will help you! Thank you! :)