Two points with same (X, Y) coordinates in Excel

**Jay**

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

**David Biddulph** · October 19th, 2006, 07:41 AM posted to microsoft.public.excel.charting

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

**Carim** · October 19th, 2006, 07:43 AM posted to microsoft.public.excel.charting

Hi,

Take a look at Jon's brilliant site :

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

HTH
Cheers
Carim

**Andy Pope** · October 19th, 2006, 09:50 AM posted to microsoft.public.excel.charting

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

**Bernard Liengme** · October 19th, 2006, 02:31 PM posted to microsoft.public.excel.charting

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

**Jay** · October 19th, 2006, 03:43 PM posted to microsoft.public.excel.charting

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** · October 19th, 2006, 04:14 PM posted to microsoft.public.excel.charting

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

**Jay** · October 19th, 2006, 04:41 PM posted to microsoft.public.excel.charting

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** · October 19th, 2006, 04:48 PM posted to microsoft.public.excel.charting

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

**Anthony D**

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode