LinkBack URL
About LinkBacks
Problem with duplicates when using LARGE() to create a pie graph of top 5
Hi all,
I am co-op'ing as a process engineer at a paper mill and our #1 paper machine has been experiencing a large number of sheet breaks everyday since last Tuesday when we had a scheduled shut down of the machine. To help troubleshoot the problem we need to know where on the machine that the sheet is breaking the most. To do this I would like to create a pie chart with six slices that shows the top 5 break points on the machine based off the frequencies that the breaks occur for each grade of paper we manufacture as well as a "Remaining Sections" slice that will be simply calculated by taking the total # of breaks and subtracting the summation of the # of breaks in the top 5. Here is a sample of break data for our 35# High Performance grade (section & frequency):
couch 2, first press 0, 2nd press 7, 1A dryers 4, 1B dryers 2, 1A-1B dryers 1, breaker stack 16, 1B-2nd dryer 4, 2nd dryer section 1, 2nd-3rd 1, 3rd 1, 3rd-4th 1. (There are more, this just gives you an idea)
My attempt at creating the pie chart consists of the following:
#1 = LARGE(A6:A17,1), #2 = LARGE(A6:A17,2).........#5 = LARGE(A6:A17,5). And to match the frequencies with their respected sections I used VLOOKUP. This method works fine for creating the pie chart that I want except when the # of frequencies for unique sections of the machine match. In this case here, my pie graph has my six slices and two of the slices are labelled as 1A dryers that have equal %'s as they should, but one slice should correspond to the 1A section and the other to the 1B-2nd Dryer section. I know that I have to use some form of "IF" statement here but I have no idea how to get both sections separated out.
Thank you!
Kyle
Register To Reply
Bookmarks