Hello!
I have a dounat-chart, I would like to filter an table with a click on a specific part of the dounat. Is it possible to conncet a macro to an Chart (I thought that it would be possible, but at least I can find out how) that can do the job or is there Another way to do it?
The chart should stay the same just the table should vary.
Hope someone understand what I am trying to do... Would be extremly greatful!!
/ Sweden
Good morning Gamla kläder
I think you may be better off rethinking your approach.
It is possible to run a macro from clicking a chart - granted, it's not the easiest thing - but Excel's event procedure structure can facilitate it. Jon Peltier has a really informative tutorial on the subject here.
But the sticking point is going to be determining exactly where on the chart a user has clicked, that kind of thing isn't handled within the standard event framework.
Depending on exactly what functionality you want, perhaps a dropdown would be more appropriate. Alternatively, you could try experimenting with Pivot Charts, with those you can click on the table for limited "interactive-ness".
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks