Change picture inside chart

**laura.gomper** · 06-19-2023, 04:08 AM

Hi guys!

I currently have around 600 charts with a picture inside each of them named "Company_Logo". Each chart has a different name, but they all start by "C_*". My company has recently changed its logo, and I would appreciate some help on this, cause I have too many charts to change it by hand.

I have tried to record a macro when changing the picture myself, but so far the macro doesn't show something useful. Could you guys give some suggestions? thank you!

**davesexcel** · 06-19-2023, 05:15 AM

Hello,
How is the picture inside the chart? or supply a sample chart with the picture.

**laura.gomper** · 06-19-2023, 05:32 AM

Please find attached an example of the chart:

Capture.JPG

**davesexcel** · 06-19-2023, 08:05 AM

An actual workbook sample would be better to see how the picture is in the chart.

**laura.gomper** · 06-19-2023, 09:28 AM

20230619.xlsx

I hope you can see it! thanks for your help

**davesexcel** · 06-20-2023, 06:05 AM

This will loop through the charts, activate each chart that starts with "C_"
-Deletes "PB_Logo"
-Inserts new logo and puts it in the top right corner,it also names the new logo.

See attached workbook

Please Login or Register  to view this content.

2023-06-20_4-01-36.jpg

**laura.gomper** · 06-20-2023, 06:25 AM

Omg, thank you so much, i will try it right now!!

**laura.gomper** · 06-20-2023, 12:16 PM

Thanks a lot for your help. I had some troubles placing the picture in the correct place so i changed picture for shape, and i used shapes.addpicture instead of pictures.insert. Thanks a lot again!