That's one more subdivision than I understood. Do the same departments
contribute to all levels, or does each level contain different departments?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Karen" wrote in message
...
Thank you so much for responding - I'm either not understanding what you
suggested or maybe I didn't explain myself correctly. I want to be able to
break down each department. For example: FY07, Level 1 has a total of 23.
There are 3 departments that are part of this total. Dept A made 5 errors,
Dept B made 12 errors and Dept C made 6 errors. I have to break down each
level and each fiscal year to compare FY07 vs. FY08. Is this a better
explanation? If so, how do I arrange this data?

Thanks again, Karen


"Jon Peltier" wrote:

blank Level 1 Level 2 Level 3 Level 4
FY07 23 20 43 81
FY08 22 40 26 90


Make sure the top left cell is blank. Make a clustered column chart. If
you
make it by row, you will have one cluster for each FY, with each level
having a column in each cluster. If you make it by column, you will have
a
cluster for each level, with one column per FY.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Karen" wrote in message
...
I charted the following data in a clustered column chart.

Level 1 Level 2 Level 3 Level 4
FY07 - Total 167 23 20 43 81
FY08 - Total 178 22 40 26 90

These are total department errors segregated by levels for each fiscal
year.
There are 3 different departments involved. What I did was just total
the
errors for each FY and each level. Now my boss wants to see how many
errors
were performed within each level by Dept A, Dept B and Dept C and
compare
the
2 fiscal years. I hope I'm explaining this properly. How can I arrange
the
raw data so I can chart this?

Thank you, Karen