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
.SeriesCollection.NewSeries
.ChartType = xlColumnStacked
.SeriesCollection(1).XValues = oSheet.Range("A1").Resize(1, 10)
.SeriesCollection(1).Values = oSheet.Range("A2").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
.SeriesCollection.NewSeries
.ChartType = xlColumnStacked
.SeriesCollection(1).XValues = oSheet.Range("A1").Resize(1, 10)
.SeriesCollection(1).Values = oSheet.Range("A2").Resize(1, 10)
.SeriesCollection.NewSeries
.ChartType = xlLine
.SeriesCollection(1).XValues = oSheet.Range("A1").Resize(1, 10)
.SeriesCollection(1).Values = oSheet.Range("A3").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.