Snip...
>That's a good advice. Where can i get the properties of the graph in order to maniplçulate it ?. I.e.: now i dont know how to append a new serie or delete one.
Hi Carlos,
PEM for graph is in ...\Microsoft Office\Office\vbagrp8.hlp. There you'll see a lot of excel constants (ie: xlChartType). To get those constants, open word or excel, select tools\macro\VB editor. Press F2, this launches "object browser". In browser, at lower part there are two windows (Classes and members). In left window find constant group (ie: xl3Dbarstacked is defined in xlChartType group), right window lists the members. Click on the one you want and value to pass is displayed beneath the windows. There is a header file (thanks to Regine Rosewich) for word constants at MS site (exact place ?) so I think there is also one for excel. If you check and find, pls email to me too.
Thanks
Cetin