Getting exact cell / Range from the pie chart

  • Thread starter Thread starter Suyog Gandhi
  • Start date Start date
S

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
 
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/
_______
 
Back
Top