View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default What is the Cell address of a Graphed point?

Hi,

Not an easy thing to do.
Firstly you need to capture the event of the point being selected. So for
that see Jon Peltier's article
http://www.computorcompanion.com/LPMArticle.asp?ID=221
He also has a couple of download file on his site.

Get Information about a Point on a Chart Sheet (zip file)
http://peltiertech.com/Excel/Zips/Ge...ChartSheet.zip
Get Information about a Point in an Embedded Chart
http://peltiertech.com/Excel/Zips/GetXYonAnyChart.zip

You will then need to decode the series formula in order to get the range
and index the correct cell.
For that see John Walkenbach's class module for manipulating the chart
series.
http://j-walk.com/ss/excel/tips/tip83.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Aaron" wrote in message
...
Is there a way to cover or click on a point on a graph and be informed of
the
cell location(s) the data is coming from? (Of course I can go to source
data
to see the range and then go find that value, but I'm looking for a better
way).

To be clear, I'm not looking for the range, I'm looking for the specific
cell or cells that make up the value my mounse is pointing to. Thanks!