Hi All,

I found a great bit of useful code online that allows me to drill down into Pivot Charts to see the individual lined data.

This allows me to let me users see what the data relates to, however, this only works on Chart Sheets.

All of the charts that the users are viewing are currently on a worksheet. I am wondering if there is any viable way of running a macro when they click any of the charts on the worksheet that then references the ChartSheet code allowing them to drill down.

I am essentially wanting all the graphs on 1 sheet, rather than split over multiple chart sheets - probably a little bit ****, but i'm sure there must be a way to do it?

The code for the drill down is:

Please Login or Register  to view this content.
Any help or suggestions would be greatly appreciated as always

Regards,
Simon