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.