combine chart types using VBA

  • Thread starter Thread starter bbussoloti
  • Start date Start date
B

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?
 
Can someone PLEASE tell me how to combine chart types using VBA?
Is it even possible?

thanks
 
Back
Top