Setting properties with VB

R

Roy Goldhammer

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?
 
J

Jon Peltier

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
 
Top