http://www.perlmonks.org?node_id=440671


in reply to Exporting an Excel Chart to PNG using Win32::OLE

Not sure if it was a typo in your code, but you define $savename in the innermost loop, but write to $savename1 (the FileName parameter) in the Export method when writing the image.
_______
Code is untested unless explicitly stated
mlh2003