Highlight point in scatter plot chart

[Erick]

Is there a way of somehow highlighting a point in a scatter plot. For example if I have a line scatter plot chart where the x-axis range from 0 to 100. I just want to identify x = 10 on the plot. This can either be a vertical line at x= 10 intersecting the plot or some sort of identifier on the plot itself where x = 10.

I hope I didn't confuse anyone.

 

[eliW]

Hi Erick,

You can do it by adding a new series of points to your chart:

Assuming your X points are ranging from 0-100
and your Y points are ranging from Y1 to Y2

(1) in your worksheet enter new set of X and Y pionts like this:

10 Y1
10 Y2

(2) Now highlight the plot area, right click to get menu, choose Sourc Data, Select Series, ADD
(3) In X value enter the X range (10,10), in Y value enter the Y range (the points Y1,Y2) and confirm.

HTH

Eli

 

[Erick]

Oh yea!, why didn't I think of that. Thanks mate.