I' m not sure if this is possible but can you click on a column in a graph which will then take you to another tab which would show you filtered data?
To explain a bit better, I have a spreadsheet that gives me information on machine breakdowns for the year. I then have another tab that shows...