Greetings, everyone. Is there any way to have Excel draw a circle around a
point on a scatterplot? I ask because I have two points with the same X and
Y values, which is causing one of the points to hide under another. Thank
you for your help.

Jay

Format/ Data Point for one of your 2 superimposed points, & choose an
appropriate symbol.
--
David Biddulph

"Jay" wrote in message
...
Greetings, everyone. Is there any way to have Excel draw a circle around a
point on a scatterplot? I ask because I have two points with the same X
and Y values, which is causing one of the points to hide under another.
Thank you for your help.

Jay

Hi,

Take a look at Jon's brilliant site :

http://peltiertech.com/Excel/Charts/...bbleSizes.html

HTH
Cheers
Carim

Hi,

Another alternative is to plot a third series which has points for only
those that overlap. Format the markers to a circle with
Forecolor = Red
Backcolor = None

Cheers
Andy

Jay wrote:
Greetings, everyone. Is there any way to have Excel draw a circle around a
point on a scatterplot? I ask because I have two points with the same X and
Y values, which is causing one of the points to hide under another. Thank
you for your help.

Jay



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

You could format a single data point to have a large marker
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jay" wrote in message
...
Greetings, everyone. Is there any way to have Excel draw a circle around a
point on a scatterplot? I ask because I have two points with the same X
and Y values, which is causing one of the points to hide under another.
Thank you for your help.

Jay

Thanks for your help. I'm sorry, but I don't have the option to change the
markers. under the format trendline dialog box, I do see the patterns tab.
however, there is no mention of any markers. in fact, I don't see anything
under the Type and Options tab either. this happens whether I right click by
the point or do to the Format menu. When I click the trendline and go to the
Format menu, I see only Selected Trendline and Sheet options. Is there
anything else to do?

J


"Bernard Liengme" wrote in message
...
You could format a single data point to have a large marker
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jay" wrote in message
...
Greetings, everyone. Is there any way to have Excel draw a circle around
a point on a scatterplot? I ask because I have two points with the same X
and Y values, which is causing one of the points to hide under another.
Thank you for your help.

Jay

Confused:

You said you had points but now you are talking about Trendlines?

Perhaps you could explain further.

Cheers
Andy

Jay wrote:
Thanks for your help. I'm sorry, but I don't have the option to change the
markers. under the format trendline dialog box, I do see the patterns tab.
however, there is no mention of any markers. in fact, I don't see anything
under the Type and Options tab either. this happens whether I right click by
the point or do to the Format menu. When I click the trendline and go to the
Format menu, I see only Selected Trendline and Sheet options. Is there
anything else to do?

J


"Bernard Liengme" wrote in message
...

You could format a single data point to have a large marker
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jay" wrote in message
.. .

Greetings, everyone. Is there any way to have Excel draw a circle around
a point on a scatterplot? I ask because I have two points with the same X
and Y values, which is causing one of the points to hide under another.
Thank you for your help.

Jay






--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy,

There is a trendline drawn through the nine points of my scatterplot.

J

"Andy Pope" wrote in message
...
Confused:

You said you had points but now you are talking about Trendlines?

Perhaps you could explain further.

Cheers
Andy

Jay wrote:
Thanks for your help. I'm sorry, but I don't have the option to change
the markers. under the format trendline dialog box, I do see the patterns
tab. however, there is no mention of any markers. in fact, I don't see
anything under the Type and Options tab either. this happens whether I
right click by the point or do to the Format menu. When I click the
trendline and go to the Format menu, I see only Selected Trendline and
Sheet options. Is there anything else to do?

J


"Bernard Liengme" wrote in message
...

You could format a single data point to have a large marker
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jay" wrote in message
. ..

Greetings, everyone. Is there any way to have Excel draw a circle around
a point on a scatterplot? I ask because I have two points with the same
X and Y values, which is causing one of the points to hide under
another. Thank you for your help.

Jay






--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Ok, but why are you selecting the trendline when it is those points you
need to format.
Use the UP/Down arrows to cycle through the chart elements. When the
points are selected use the left/right to move through each point in the
series.
When you get to the point use CTRL+1 to bring up the format dialog.

Cheers
Andy

Jay wrote:
Andy,

There is a trendline drawn through the nine points of my scatterplot.

J

"Andy Pope" wrote in message
...

Confused:

You said you had points but now you are talking about Trendlines?

Perhaps you could explain further.

Cheers
Andy

Jay wrote:

Thanks for your help. I'm sorry, but I don't have the option to change
the markers. under the format trendline dialog box, I do see the patterns
tab. however, there is no mention of any markers. in fact, I don't see
anything under the Type and Options tab either. this happens whether I
right click by the point or do to the Format menu. When I click the
trendline and go to the Format menu, I see only Selected Trendline and
Sheet options. Is there anything else to do?

J


"Bernard Liengme" wrote in message
. ..


You could format a single data point to have a large marker
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jay" wrote in message
.. .


Greetings, everyone. Is there any way to have Excel draw a circle around
a point on a scatterplot? I ask because I have two points with the same
X and Y values, which is causing one of the points to hide under
another. Thank you for your help.

Jay




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi Jay,

One way to achieve this perhaps would be to add a second series for
duplicate points. The same format can be used as for the original series, but
using a large circle as the marker with no background colour - looks like a
circle around the point.

Hth
Anthony

"Jay" wrote:

Greetings, everyone. Is there any way to have Excel draw a circle around a
point on a scatterplot? I ask because I have two points with the same X and
Y values, which is causing one of the points to hide under another. Thank
you for your help.

Jay