You can't do this directly. You can use a trigger that fires when you make a selection in a field. Add a Activate Sheet action to the OnSelect field trigger of that field. You can find those triggers on the Triggers tab of the Document Properties window.
Yes, As gwassenaar said there is no direct option.
adding another option is that :
On top of the straight table add one dummy text object and give action to that text object.
So that where ever you click on the chart it will open the required sheet