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

thanks

"bbussoloti" wrote:

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).ChartTy pe = 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?