>Hi,
>
>What is the syntax to change the chart added in EXCEL? I have tried the following but cannot work :
> ...........
> oXLChartM.Charts.Add
> oXLChartM.ChartTpe='xl3DColumnstacked'
>
>I think somehow the xl3DColumnstacked should be some code but I do not know what is the code.
>Thanks.

Actually the constant is : xl3DColumn
so you neeed
oXLChartM.ChartTpe= xl3DColumn
oldcChartM.ChartGroups(1).subtype=2
1 for segmented, 2 for stacked