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?