Stacked column chart
 

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?

Stacked column chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JenF" wrote in message
...
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?

Stacked column chart
 

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" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JenF" wrote in message
...
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?

Stacked column chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JenF" wrote in message
...
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" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JenF" wrote in message
...
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?

Stacked column chart
 

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.

--
Thanks,
Shane Devenshire


"JenF" wrote:

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" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JenF" wrote in message
...
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?