combine chart types using VBA

[bbussoloti]

I'm trying to create a chart combining lines with columns. I know it can be
done manually, so I recorded a Macro to show me what commands to use.

It recorded, for example:
ActiveChart.SeriesCollection(seriesNumber).ChartType = xlColumnClustered

When I use this command on my VBA code changing the series from a xlLine
Graph to xlColumnClustered, my whole graph series becomes Columns, not only
the one I wanted to change.

Can this be done by other way?

 

[bbussoloti]

Can someone PLEASE tell me how to combine chart types using VBA?
Is it even possible?

thanks

 

[bbussoloti]

Ok i've done it. Thanks

Can someone PLEASE tell me how to combine chart types using VBA?
Is it even possible?

thanks