combine stacked bar charts

[Guest]

I am trying to combine 3 stacked bar charts into one chart. Everytime I try,
the data mixes up and doesn't come out correctly. Any suggestions?

 

[Jon Peltier]

Do you just want three series stacked upon each other? Make the chart with
all the data to begin with. If the data is not convenient to select all at
once, make the chart with some of the series data, then copy more data,
select the chart, and go to Edit menu > Paste Special, and add the data as a
new series. Repeat as needed. If you need to, go to Chart menu > Chart Type,
and reselect the stacked column type.

- Jon