Roy -

Another oft-helpful trick. Turn on the macro recorder and make the
change you want to program. Excel will give you some code you can use
as the basis for your macro.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Roy Goldhammer wrote:
Hello there

I have chart that i need to change some types, caption locations ect... on
runtime because these elements are diterme according to the data which the
chart got.

Is there a way to control Chart by code?