Excel 2002. I have a group of 6 different stacked bar charts built from
parts of a pivot table. Each graph has several bars with each bar
having sections for categories "10", "20", "30", "40", and "50". The
graphs can be direct linked to the pivot table (as a pivot chart) or
linked to an intermediate sheet looksup the data from the pivot table.
I want to be able to click (double or single click) on a graph bar or
section of a bar and execute the same action (.ShowDetail) that occurs
when you double-click on a cell in the pivot table (print the
corresponding sub-set of the data on a new sheet).

To do this I need to determine which graph bar (or section of the
stacked bar) was clicked and relate that to the appropriate cell in the
pivot table. Then I can select that cell in the pivot table and execute
"Selection.ShowDetail".