Drawing circle at (x,y) cordinates

**intelligently_dumb** · 01-28-2009, 08:05 AM

I have three columns in my worksheet. They give x,y coordinate and radius of circles. I want to create circles at these coordinates with these radii. Overlapping is not a problem as that depends on my coordinate calculation. Can anyone please help me??

I am a beginner at excel programming....

**barriecusvein** · 01-28-2009, 08:10 AM

You could just use a bubble chart. Arrange the data in 3 columns X, Y and radius. Plotted as a bubble chart will give what your looking for.

**Andy Pope** · 01-28-2009, 09:19 AM

barriecusvein, the bubble chart would certainly draw circles at given xy points but the control over the radius of the circle will be limited and related to the other radii. This approach may work but will rely a lot on the source data.

You could generate a set of 361 points that describe the circumference using simple trig formula and plot the data as xy-scatter series.

**intelligently_dumb** · 01-28-2009, 10:05 AM

this returned a chart... i dont want axis actually.. i mean a position on the sheet by (x,y) coordinates. Like the way we draw in Qbasic or C++..

**Andy Pope** · 01-28-2009, 10:11 AM

You would use an autoshape.

Assumes X,Y and Radius values are in A1,B1 and C1

Please Login or Register  to view this content.

**barriecusvein** · 01-28-2009, 10:55 AM

Originally Posted by Andy Pope

barriecusvein, the bubble chart would certainly draw circles at given xy points but the control over the radius of the circle will be limited and related to the other radii. This approach may work but will rely a lot on the source data..

I didn't realise bubble charts did this. I though the radii were directly proportional to the data.

**Andy Pope** · 01-29-2009, 06:56 AM

You are correct the radius is iroportional. But that means you can not specify a exact size

Create a set of data where the bubble size for all the bubbles is 1.
Now set 1 of the bubble to a size of 10. This bubble will now be the same diameter and the previous 1 sizes. Now change another size to 20. Again 20 will be the larger, 72pt data marker, and 10 will halve.