What is the Cell address of a Graphed point?

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

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!
 
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/GetXYonaChartSheet.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
 
Back
Top