Re: Sub-Categories of Information on the same plot line
From: Jon Peltier (jonxlmvpNO_at_SPAMpeltiertech.com)
Date: 03/18/04
- Next message: Jon Peltier: "Re: Pull down menu (combo box) on chart sheet"
- Previous message: Eric: "Removing line segment in line chart"
- In reply to: LorieA: "Sub-Categories of Information on the same plot line"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 18 Mar 2004 17:22:34 -0500
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?
>
- Next message: Jon Peltier: "Re: Pull down menu (combo box) on chart sheet"
- Previous message: Eric: "Removing line segment in line chart"
- In reply to: LorieA: "Sub-Categories of Information on the same plot line"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
