What we encourage people to do when using VBA is to run the Excel chart
recorder while performing the action they want to do in VBA, then fix up the
inefficient VBA recorded code and incorporate it into their project. You can
do the same thing, although there may be an additional step where you
translate or at least reference the VBA code so it works as VB.Net code.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MacAndy" wrote in message
...
I have a template file in Excel which contains some sample charts. I need
to
generate some charts which has the same format as that of sample charts.
I'm
using VB.NET 2005.