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?