combine chart types using VBA
 

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?

combine chart types using VBA
 

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?

combine chart types using VBA
 

Ok i've done it. Thanks

"bbussoloti" wrote:

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?