Sub-Categories of Information on the same plot line

I have a s/s tracking late shipments. Each column represents a different reason for being late with the total # of shipments that fall into that category under it. Each day of the week is tracked on the following rows. I have a case of one reason falling under another, i.e., Incomplete Order and Items on Quality Hold. The reason some orders are Incomplete is that some items on the order are on Quality Hold. So....I'd like to be able to represent on a bar chart that out of 29 Incomplete orders, the contributing reason for 10 of them is items on Quality Hold. Any suggestions?

Lorie -

You could make a stacked bar (or column) chart, and stack Quality Hold
and other reasons above the same category. So if your category names are
in the top row, you need more than one row of data:

Incomplete Misread PO Whatever
Late Shipments 23 11 8
Quality Hold 12

Select this data and make a stacked bar or column chart. The 23 stacks
on the 12 on the Incomplete category. Make sure that you subtract
Quality Hold from the total, so you don't count errors twice.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

LorieA wrote:
I have a s/s tracking late shipments. Each column represents a
different reason for being late with the total # of shipments that
fall into that category under it. Each day of the week is tracked on
the following rows. I have a case of one reason falling under
another, i.e., Incomplete Order and Items on Quality Hold. The
reason some orders are Incomplete is that some items on the order are
on Quality Hold. So....I'd like to be able to represent on a bar
chart that out of 29 Incomplete orders, the contributing reason for
10 of them is items on Quality Hold. Any suggestions?