combine chart types using VBA

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?
 
B

bbussoloti

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

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Graphs + VBA 1
Adding Chart problem 0
xlStockVOHLC chart with extra xlColumnClustered series 0
Chart error 2
bubble Chart bubblesize problem in VBA 3
need help adding named range as new series to a graph 1
Creating Charts using VBA 0
Copy chart to new location 7

Top