Setting properties with VB

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

 

[Andy Pope]

Hi Roy,

Here is a good place to start.
(http://www.geocities.com/jonpeltier/Excel/Charts/index.html#hdrVBA)

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?

--

Cheers
Andy

http://www.andypope.info

 

[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