Need help with VB making combine chart on excel

[supermanii]

Hi everybody, I have a problem in vb6 code. I would like to make a chart on excel file with vb and I can make it with this code.

With oChart
.SeriesCollecti on.NewSeries
.ChartType = xlColumnStacked
.SeriesCollecti on(1).XValues = oSheet.Range("A 1").Resize(1 , 10)
.SeriesCollecti on(1).Values = oSheet.Range("A 2").Resize(1 , 10)
End with

It works fine for 1 serie.

But I have 2 series to make, first serie is column type chart and second serie is line type chart. And I put this code.

With oChart
.SeriesCollecti on.NewSeries
.ChartType = xlColumnStacked
.SeriesCollecti on(1).XValues = oSheet.Range("A 1").Resize(1 , 10)
.SeriesCollecti on(1).Values = oSheet.Range("A 2").Resize(1 , 10)

.SeriesCollecti on.NewSeries
.ChartType = xlLine
.SeriesCollecti on(1).XValues = oSheet.Range("A 1").Resize(1 , 10)
.SeriesCollecti on(1).Values = oSheet.Range("A 3").Resize(1 , 10)
End with

The result is appeared 2 series with only Line type.
How I make 2 type graph on 1 graph? Please, suggest me.

Jr.

[mishras2009]

hello firends
i am also suffering such a problem and iaam not been able to find out stddev() in vb vtchstates so if you have any solution kindly send me