The simplest way to generate the code would be to make use of the macro
recorder. Just turn it on and perform the required steps in order to
format your chart.
For more information see Tushar's page,
http://tushar-mehta.com/excel/vba/be...rder/index.htm

Cheers
Andy

Steeplechase wrote:
Hello There!
Thanx for your help. That actually works very well. Is there a way in
VBA to do those steps automatically? For example by just selecting a
graph and clicking on one single button?

I appreciate your help.

Steeplechase



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info