I am unable to upload a print screen, so I will attempt to insert the table below? the table shows the teams (48-62), the year, period and the week of that period, and Efttl which is overall total.

I would like to create a graph with slicers, so the viewer can select the year (from list of 3) and also the team they would like to look at, with the option via the slicer to look at them all, or compare teams.

I can't make it identify the 48-62 as teams, years I am OK.

Prd Wk 48 49 55 60 62 Efttl Year
01 1 57% 70% 84% 77% 72% 68% 2015
01 2 70% 85% 68% 72% 84% 77% 2015
01 3 66% 58% 79% 84% 87% 74% 2015
01 4 59% 84% 66% 70% 56% 69% 2015
01 5 2015
02 6 51% 78% 73% 72% 81% 72% 2015
02 7 62% 92% 66% 70% 80% 75% 2015
02 8 63% 71% 94% 59% 83% 72% 2015
02 9 58% 74% 76% 82% 75% 73% 2015
03 10 62% 76% 77% 84% 71% 71% 2015
03 11 62% 93% 71% 67% 72% 70% 2015
03 12 64% 71% 90% 76% 65% 75% 2015
03 13 49% 91% 88% 71% 63% 70% 2015
04 14 48% 74% 80% 68% 60% 66% 2015
04 15 76% 79% 86% 76% 71% 74% 2015
04 16 68% 83% 83% 74% 69% 73% 2015
04 17 58% 87% 81% 74% 65% 72% 2015
05 18 63% 78% 66% 85% 67% 71% 2015

I would like to bring information from a number of different management sheets into one worksheet, I know I'll need to update it each month.

Maybe a power pivot allows me to link different information into one. As I am not able to do this probably very simple task I am abit stuck before I start.

I thought this would be the easiest one :-(

Feeling rather deflated.

Thank you
Clair