Personally, I've had my pains with working with the Win32::OLE module. As an alternative, I've exported the data to CSV and the used GD::Graph to generate my charts. This may not be exactly what you're looking for, but if you do have probems with the module it may be a viable alternative.
Hope this helps.