Hi guys..
Sorry if something similar has been posted, I've had a look around, but am learning as I go along, and don't even know what I'd be searching for :/..
I've attached a spreadsheet here where I've tagged a game of football, and listed the actions (goalkick, fouls conceded, crosses, etc.). I've used a scatter graph then to show where these actions happened on the pitch (using a football pitch background on the graph)..
I've turned the listed actions into a table, so it allows me filter the data shown. In this way the coach can select the info he wants to see, ie. goalkeeper distribution (successful or not), or what sides of the pitch are our team more successful in getting crosses into the box, what side of the pitch are we conceding too many crosses/fouls etc. etc. etc..
I'm wondering whether it's possible to hide the data in the tables, just showing the titles, and the graph representing whatever's selected? I've tried hiding the rows but when I select something, the list appears once more and the graph drops down out of sight. I'm just really looking for a way to clean up this report, as I'll be attempting a dashboard type thing, showing different kpi's on the one sheet???
Thanks for any help..
Adrian.
Bookmarks