Getting exact cell / Range from the pie chart

[Suyog Gandhi]

By selecting data point on the pie chart, I want to get corresponding
cell/range ( e.g E6 or E6:E8). I can get the values (
ActiveChart.SeriesCollection(1).Values), but can't seem to find how to
get exact cell.

Will appreciate your reply.

Thanks
Suyog

 

[Jon Peltier]

Suyog -

Excel doesn't make it easy. You can get the series formula, and parse it
to extract the range of interest. John Walkenbach shows how to use a
class module to do just this on his web site, http://j-walk.com.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______