Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a preato from a group of data choosen from a pivot chart
I am a novice at excel so please help.
I am trying to display an assembly line's downtime graphically. I current have columns of data. Date, Machine, Min, detail, 4M(man, material, method, machine), shift. I currently have a pivot chart to show the entire line downtime per machine. But I am wanting the top three of the pivot chart be broken down in another pivot chart or regular chart by the Machine, Min, Detail. I have set the cells in the pivot chart equal to a cell out side of the pivot chart to basically copy the top 3 positions. I need these top three machine names to be filtered out of a data base and then graph the detials(why the machine was down) and how long in a chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table - show top 20 and group remaining data | Excel Discussion (Misc queries) | |||
How do you group data in a Pivot Table? | New Users to Excel | |||
Creating a graph based on a chosen group of data | Charts and Charting in Excel | |||
Why does the pivot table not allow me to group data? | Excel Discussion (Misc queries) | |||
Pivot table/chart - can I use data ranges? why will it not group d | Charts and Charting in Excel |