ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Two points with same (X, Y) coordinates in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/115089-two-points-same-x-y-coordinates-excel.html)

Jay

Two points with same (X, Y) coordinates in Excel
 
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



Anthony D

Two points with same (X, Y) coordinates in Excel
 
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





All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com