I've created a class module to capture a Shift+Click on a pivot chart,
which then opens the data associated with that point. It works great
on pivot charts on their own sheet, but when I use the same code on an
embedded chart, it fails (error code 2147417848).

Everything seems to work fine, it derives the same row and column
values as needed, but the ShowDetail property is unavailable in the
embedded charts.

Anyone have any insight?


james Igoe || ||
http://code.comparative-advantage.com

I eventually solved my problem, simply using "On Error Resume Next",
capturing the error number if it existed, then opening the range
manually via selection.

It is less than ideal, but my attempts to use the ChartObject for
embedded charts was not fruitful.

If interested, visit my website and find it among my Excel VBA
offerings.

James Igoe

646.303.2584 || ||
http://code.comparative-advantage.com