There seems to be something missing in the use case here, as why would you redirect someone when they click on a chart? I agree with the other poster, the best option would appear to be a Button object on the sheet with the chart the users can click that will do the Action to move them to the other sheet etc. If you can expand upon the use case, may be able to come up with something else, but again, things not making a lot of sense at the moment.
If the Button object did do the trick, please be sure to give the other poster credit by using the Accept as Solution button. Here are some other links that may be handy related to Actions and Triggers:
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.