Stacked column chart

[JenF]

I'm trying to create a stacked column chart that will essentially behave like
a pie chart in column form. I want to display the total excess inventory per
employee, broken down by that particular employee's desk codes. It works
fine when I input the data as a pie chart, but we would like everyone to be
next to each other in column form because it is easier to consolidate. Is
this possible? If so, how can I format the data so that it stops creating
separate columns for each desk code?

 

[Jon Peltier]

Does each employee have a unique column? List the employees in column A, the
desk codes in row 1, keep cell A1 blank, and populate the grid with the
appropriate values. Make a stacked column chart with series in columns.

- Jon

 

[JenF]

The problem with that is that each column would represent a particular
employee, and each employee has multiple, different desk codes. The way that
you suggest only works if I am doing one employee, from what I can tell.

Ex.

Joe has desk codes 6, 7, 8, 10 and each code has a different amount
associated with it.
Pam has desk codes 2, 3, 4, 5...
etc.

Is this possible?

 

[Jon Peltier]

It does not sound like you tried it, because it will work.

6 7 8 10 2 3 4 5
Joe x x x x
Pam x x x x

- Jon

 

[ShaneDevenshire]

Hi Jen,

Unless Jon and I missunderstand you question, Jon's solution will work.
DC1 DC2 DC3
Emp1 3 6 2
Emp2 5 8
....

1. Select all the data, notice Emp2 doesn't have a deskcode1 value, no
problem.
2. Click the Chart Wizard, and select Column, and the Chart Sub-type #2,
3. Click Finish or go throught the rest of the wizard.