View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bbussoloti bbussoloti is offline
external usenet poster
 
Posts: 13
Default 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?