Embedded Chart Versus Chart - ShowDetail Issue

J

james.igoe

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 || (e-mail address removed) ||
http://code.comparative-advantage.com
 
J

james.igoe

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 || (e-mail address removed) ||
http://code.comparative-advantage.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded Chart Versus Chart - ShowDetail Issue 1
Pivot Chart Drilldown 3
pivot table from recordset - very slow performance 1
Pivot Chart Drilldown 1
Excel Charts and Shapes or Text Boxes that disappear 0
pivot table from recordset - slow performance 4
ChartAdd event for embedded charts 10
On Error GoTo Label in a loop only working once. 4

Top