What is the Cell address of a Graphed point?

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!
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Creating a Chart on form from selected data in query. 0
Graph Line Width ? 1
XY Scatter graph: x-axis picking up row numbers instead of values 3
Suppres Zero or empty Cell value in a line graph 1
How to reorder data points on a graph? 1
Mail Merge query 1
Excel graphing and equation issues 3

Top