Get Data table from Excel Chart (pivot chart)

[Nexus981]

Hi,

I have created a Pivot Chart with Slicers etc. After the user selects the date ranges and filters. IS there a way to then export that view to a data table? Kinda of like in a regular pivot table you can click on the totals and then get the raw data related to that number?

My users are asking for visuals but I know they will need a table view as well as some of the individual value matter and knowing and seeing the exact value is as important as seeing the value relative to the group.

Thanks In Advance For The Help!

Andre

 

[Worf]

Hi

o What Excel version are you using?
o Below is a VBA solution for a chart sheet. Please confirm you are using an embedded chart and I will prepare the required class module.

Private Sub Chart_MouseUp(ByVal Button&, ByVal Shift&, ByVal x&, ByVal y&)
Dim ElementID As Long, Arg1 As Long, Arg2&
' creates data table based on clicked element
' Pass: x, y. Receive: ElementID, Arg1, Arg2
ActiveChart.GetChartElement x, y, ElementID, Arg1, Arg2
If ElementID = 3 Then       ' data element
    ActiveChart.PivotLayout.PivotTable.DataBodyRange.Cells(Arg2, Arg1).ShowDetail = 1
    ActiveWindow.FreezePanes = 1
End If
End Sub