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