Sub-Categories of Information on the same plot line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top