macro for pivot chart to show filtered data

[ghynes]

hello,

i have a pivot chart created from a big database table. is there anyway i can write a macro when i click on the table, it will show the data thats filtered in the table on another sheet?

 

[Misca]

You don't even need a macro to do that: Just doubleclick a value on the PivotTable data range and you should get what you're after.

Or have a look at http://www.contextures.com/xlPivot-Filter-Source-Data.html for the macro solution.

 

[ghynes]

it works for the pivot table.. but not for the chart.
is there anyway i can click on the bar chart to show the data?