According to my exprience the following approach is the easiest/fastest:
In reply to Re: Prepare charts using Win32::ole by Ratazong in thread Prepare charts using Win32::ole by soumyapanda