Stacked Column Problem

[Galen]

Runing Excel 2000 on Windows 2000.

I have a table of data containing 2003 productivity data
by month for 3 teams, each of which has 3 members.

The table is arranged with the months January through
December on the top row.

The first column on the right of the table is the team
name (cells merged to span three rows corresponding to
team members), the second column contain's the team
members' names. The next 12 columns contain monthly
production data for each team member on the row
corresponding with their name.

I am trying to come up with a way to create a separate
stacked line chart for each month that shows the team
names on the X axis and the productivity on the Y axis and
the team members as part of a stacked line for each team.


Any Suggestions??

Here is my attampt to show the table layout...

---------------Jan--Feb--Mar--Apr--May--Jun--Jul--Aug
-------Agent 1--2----3----3----4----4----3----5----3
Team 1-Agent 2--3----4----5----6----7----3----4----4
-------Agent 3--3----4----2----0----2----2----4----1
-------Agent 4--2----3----4----5----2----4----2----0
Team 2-Agent 5--3----0----2----3----4----2----4----2
-------Agent 6--2----3----3----4----4----3----5----3
-------Agent 7--2----3----3----4----4----3----5----3
Team 3-Agent 8--2----3----3----4----4----3----5----3
-------Agent 9--2----3----3----4----4----3----5----3

 

[Debra Dalgleish]

Select a cell in the table, and click the Chart Wizard button.
Select the column chart type, and the stacked column subtype.
Click Finish, or continue through the chart wizard to select options

 

[Nicky]

Hi Galen,
Is this what you're after

Attachment filename: side by side stacked columns.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=44112

 

[Galen]

Perfect! Thanks!