Creating a chart in VBA with 2 different Types

Question

In VBA, I'm attempting to programmatically build a chart. Three series must be present in the chart, two of which must be xlColumnStacked and one of which must be xlColumnClustered. One series will be of the xlColumnClustered type, while the other two will be stacked, according to the plan. The two columns will then be compared side by side as a result.

Can this be done?

Answer 1

Can you carry this out by hand using the UI? Is what you're doing in the UI and the code conceptually equivalent? You must choose the exact series whose type you want to alter using the UI. Instead of setting the type of the entire chart, are you doing this in code?

For anything to do with Excel charts, I would recommend John Peltier's site