scattergraph not referencing all data in a scrolling table??

[aidovaughan]

Hi guys..

I posted a similar question to this a week or 2 ago, and got a reply that got me moving in the right direction (thanks Andy)..

I'll upload my sheet here if it helps.. I'm attempting to design a dashboard based on football kpi stats.. I tag a number of actions, players involved and the outcomes, and am trying to make all these stats easily understood by players & management.

On page 1 of me sheet, I have a scattergraph linked to the table below it, showing the pitch coordinates of where an action took place. There can be hundreds of these actions, and since I don't want a giant list on the report, I've used a scroll-bar to keep this table as short as possible.. 3 lines in total. I've used the offset function then to link the scrolling table to the list of data on page 2.

This is working fine.. apart from the fact, because only 2 lines are being shown at any one time on the table, only two corresponding coordinates are being shown on the scatter graph.. This means that if a coach wants to view a particular action.. eg. where we were shooting from, and who took the shots, he'll only see 2 coordinates, when there could be 20 actual values that are not being shown :/.. so this ain't gonna work..

(sorry if I'm rambling.. just trying to give an understanding of my problem).. I don't want to make the table any longer and take up space on the final report. Is there some way to allow the scattergraph reference all these values in the scrollable table, and not just the 2 that are shown at the time??

thanks for any help,
adrian...