Is there a way to create a chart that allows the user to click on a bar or piece of the pie that links him to another chart that shows a detail based on which piece he clicked on. I see that there are 'Drill Into' and 'Drill Out' buttons grayed out when opening a query in pivot chart view, but I think I need to start with a chart in a report.
Thanks in advance,
Patrick