Multiple types of charts in one chart

[Alan]

Is it possible to do the following:

Stacked bar chart for 3 data series.
Regular bar chart for 1 data series.
Line chart for 1 data series.

I've used the custom "line-bar chart 2 axes" combination chart which nearly
solves the issue, except that it won't allow me to split up the bar charts.

Alternatively, I've also managed to get it "working" except that the bar
charts block each other. Is there a way of shifting the bar charts so they do
not overlap?

I am using Office 2003.
Thanks!

 

[smartin]

Is it possible to do the following:

Stacked bar chart for 3 data series.
Regular bar chart for 1 data series.
Line chart for 1 data series.

I've used the custom "line-bar chart 2 axes" combination chart which nearly
solves the issue, except that it won't allow me to split up the bar charts.

Alternatively, I've also managed to get it "working" except that the bar
charts block each other. Is there a way of shifting the bar charts so they do
not overlap?

I am using Office 2003.
Thanks!

Put all your stuff in some chart. When viewing the chart, right click a
series, select "chart type", and pick your fave for that series.

Rinse and repeat.