Hi Jaya,
I do not know exactly wherefore you will use this charts, but in past I used Excel template files to define the style of charts.
Some month ago I've created a script to generate an report with some charts in Word. Therefore I used a word template to define the styles in the document.
The charts where created based on a set of Excel template files, which already containing the chart. So you can easily manage the style of chart in template and use doors only to update the information used in the charts.
After creation of one chart it was be copied via clipboard into word document.
May be this solution is useable for your work too ?!
It will keep you away a little bit from dealing with the OLE/VBA stuff
Greetings
Reik Schröder
-------------------------
Evosoft GmbH
for Siemens Industry Sector
Berlin, Germany
Edited: 10-Jul-2006
at 09:16
by Reik Schroeder