Click on stacked bar chart and open another sheet with the details

[Anonymous]

Hi,

I have a stacked comparison chart that I need to click on each individual value and open up a distinct sheet with the details.  For example I would like to click on value #1 and open up sheet number 1 with the details.

I have tried to do this with field event triggers, but it does not seem to work. Maybe this approach does not work for stacked charts.  I don’t want to create buttons to get to the appropriate sheet. Any ideas or suggestions on how to make this work?

Below is an image of my chart.

Thanks in advance for your help,

Lourdes