Embedded Chart Versus Chart - ShowDetail Issue
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 |
Embedded Chart Versus Chart - ShowDetail Issue
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 |
All times are GMT +1. The time now is 09:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com