Hi
I wonder if this is possible
My data is like this, gathered from yearly sheets in the same workbook
Year Team Points Place
1971 A 23 1
1971 B 22 2
1971 C 21 3
1972 B 27 1
1972 F 25 2
1972 D 20 3
1973 B 31 1
1973 A 25 2
1973 G 24 3
.
.
.
etc...
In other words, the top 3 teams in an annual competition and their points from each sheet
What I'm wondering is if it's possible to get a Pivot Chart to create something like:
1971 1 A 23 2 B 22 3 C 21
1972 1 B 27 2 F 25 3 D 20
1973 1 B 31 2 A 25 3 G 24
.
.
.etc.
IE A yearly list of 1st, 2nd and 3rd placed teams with their points
I've been able to create a Pivot Table summarising each teams top 3 placings by putting 'Place' in the columns and Team in the Rows, then reverse sorting to give a chart of the most successful teams, but struggling to work out if the above is possible.
Thank you for any thoughts
Bookmarks