Windson:
I am not sure whether I can help you here. If you select a data point and
you move it Excel pops up a Goal Seek with the cell reference of the data
point.
Another way to visualize is to copy yr data column (as values). The copied
values you can conditionally format (Format/Conditional Format...) in
comparison to the data series (if(A<B, "make cell B yellow","") for
instance). Now if you move a point by hand the cell that changes turns
yellow, triggered by the conditional format. Write down the cell reference,
and restore by Ctrl-Z to move the data point back in place.
HTH,
Henk

"Windson" wrote:

Hi, I am curious to see if anybody could create a visual relationship between
a point on the chart and the data cell. Let's say if we have 1000 points on
the chart, when I point to one of them--it will show the values--but I still
have no idea where the point actually comes from. Or on the other hand, when
I try to hightlight some cells using formats, the best thing is to see the
points on the chart also being highlighted in some way.

Thanks for any hints there.