Two column stacked chart

  • Thread starter Thread starter Erin
  • Start date Start date
E

Erin

Is it possible to create a stacked chart so that Team B is
stacked on Team A to create one total column with two
colors, but also add Team B on Team A for 2003 right next
to it? (Each of these pairings would be repeated across
regions - North, South, East, West - for a total of 4
pairs of columns with two colors for each column). Not
sure if this can even be done, but it seems like it should
be possible. Any suggestions would be appreciated.
Thanks.
 
Set up your data like this:

TeamA TeamB
Region1 2003 580 302
2004 290 775
Region2 2003 580 302
2004 290 775

Then, select a cell in the table, and click the Chart Wizard button.
Select the column chart type, and the stacked column subtype.
 
Back
Top