It's not clear to me exactly what you want. It would probably be helpful to provide some hand-worked examples to illustrate what you are trying to do here.

Are you familiar with the LARGE() function? https://support.office.com/en-us/art...b-01672ec00a64 My first thought is to put something like =LARGE(B$2:B$9,$AA15) (where AA15, AA16, and AA17 contain 1,2,3) into B15. Then copy down and across, note how I used a mix of relative and absolute references to make it easy to copy the formula. This will yield a matrix that consists of the largest three values for each year. Then you can chart those values on a column chart.