Thread: how to highlight a cell so I know which point on the chart it is?

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.

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.

HEK:

Thanks. Both ways defenitely help to find the reference cell of the data
point. And can you hightlight data points on a chart by highlighting the
reference cells?

Windson


"HEK" wrote:

> 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.