Excel export selected charts as ppt

**Manish84** · 08-18-2015, 10:33 AM

Hi friends,

I have a file with few charts. I am trying to export few of the charts from excel to a new PowerPoint. I have written the code for this and it is working fine, but few things are there with the code which i am trying to remove. It would be of great help if you can help me in overcoming these obstacles.

- While exporting the charts, PowerPoint application becomes active (and it shows the whole process). Is there any way to minimize it and do the export or can we keep excel sheet as active and do the export. I even tries to comment the below code, but it didn't helped me

HTML Code:

- Can we middle and center align the exported charts in ppt
- is there anyway to shorten the code by looping the export process (but only selected charts need to be exported)

Please find attached the sample file
Export charts to ppt.xlsm

Thanks,
Manish

**FerJo** · 08-27-2015, 08:31 PM

Here you go...

Just 2 considerations:

1) I have aligned all the charts exactly, and also with the same exactly size and in the same position respect the cells surrounding them... thus, you will always get the same chart size (and position) when exporting as an image.

2) The cells sorrounding each chart are a in a sheet-level defined named range, with the name of the chart that you want to appear in the chart selection form.

Every line I have added (quite a few) are commented, so you don't lose track of what is going on... and also, you will learn some new stuff.

¡Adios!