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:

Private Sub Chart_BeforeDoubleClick(ByVal ElementID As Long, ByVal Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)

ActiveChart.PivotLayout.PivotTable.DataBodyRange. _
            Cells(Arg2, Arg1).ShowDetail = True

End Sub
Any help or suggestions would be greatly appreciated as always

Regards,
Simon