How to Draw a Circle in Excel with a Specific Radius – 3 Methods

 

 

Method 1 – Utilizing the Parametric Equation of a Circle

The parametric equations of a circle are:

x = r cos(t) 

y = r sin(t)

x, and y are the coordinate points, r is the radius of the circle, and t is the angle subtended by the radius at the center of the circle.

If we find the x, and y values and plot them in an Excel Scatter Chart, we will get a circle.

 

This is the sample dataset.

how to draw a circle in excel with specific radius

Steps:

  • Create a table.

Utilizing Parametric Equation of Circle to draw a circle in excel with specific radius

  • Enter the following formula in C5.
=$F$5*COS(B5)

F5 is the Radius of the circle, and B5 is the first cell of the Angle column. The COS function returns the x value of the coordinate.

  • Press ENTER.

Using COS function to draw a circle in excel with specific radius

This is the output.

  • Use the AutoFill to see the result in the rest of the x values.

  • Enter the following formula in D5.
=$F$5*SIN(B5)

F5 is the Radius of the circle, and B5 is the first cell of the Angle column. The SIN function returns the y value of the coordinate.

  • Press ENTER.

Using SIN function to draw a circle in excel with specific radius

 y values will be displayed in D5.

  • Use the AutoFill to see the result in the rest of the y values.

  • Select the R*COS(Angle), and R*SIN(Angle) columns.
  • Go to the Insert tab.
  • In Charts, click  Insert Scatter (X,Y) or Bubble Chart.
  • Select Scatter with Smooth Lines.

Using Scatter Chart to draw a circle in excel with specific radius

The following chart will be displayed.

  • Customize the scatter chart and to see the following final output.

A circle with a radius of 10, using the parametric equations of the circle.

Final output of method 1 to draw a circle in excel with specific radius

Read More: How to Create Concentric Circle Chart in Excel


Method 2 – Using the Shapes Option

Steps:

  • Go to the Insert tab.
  • In Illustrations, click Shapes.

Using Shapes Option to draw a circle in excel with specific radius

  • Choose Oval.

  • Press and hold SHIFT.
  • Draw a circle on your worksheet.

  • Right-click any point inside the circle.
  • Choose Format Shape.

 

  • In the Format Shape dialog box, select No Fill in Fill.
  • Choose Solid line in Line.
  • Increase the Width to 2 pt.

Editing Format Shape options to draw a circle in excel with specific radius

  • Go to Size & Properties. In the Format Shape dialog box:
  • Enter the Height: It should be the double of the radius. Here, 2.
  • Enter the Width. It should be the same as the Height.

  • Close the Format Shape dialog box.

This is the output.

Final output of method 2 to draw a circle in excel with specific radius

Read More: How to Draw a Mohr Circle in Excel


Method 3. Applying the VBA Macro Feature.

Steps:

  • Go to the Developer tab.
  • Choose Visual Basic in Code.

Applying VBA Macro Feature to draw a circle in excel with specific radius

The Microsoft Visual Basic window will open.

  • Go to Insert.
  • Choose Module.

  • Enter the following code in the Module.
Sub CircleGenerator()
Dim rad As Long
rad = InputBox("Insert the radius of the circle")

With ActiveSheet.Shapes.AddShape(msoShapeOval, 200, 200, rad * 2, rad * 2)
.Name = "CIRCLE"
.Fill.ForeColor.RGB = vbWhite
.Line.Transparency = 0
.Placement = 1
End With

End Sub

Writing VBA code to draw a circle in excel with specific radius

Code Breakdown

  • A sub-procedure is created: CircleGenerator.
  • A variable:rad is declared and defined as Long.
  • The value of rad is taken, by using an InputBox statement.
  • The With statement specifies the characteristics of the circle.
  • The With statement is ended.
  • The sub-procedure is ended.
  • Click Save.

  • Press ALT + F11 and you will be redirected to the worksheet.
  • Press ALT + F8 to open the Macro dialog box.

  • Select CircleGenerator.
  • Click Run.

Running Macro to draw a circle in excel with specific radius

 

  • Enter the radius. Here, 30.
  • Click OK.

A circle with a radius of 30 is displayed.

Final output of method 3 to draw a circle in excel with specific radius

Read More: How to Circle Something in Excel


Steps:

  • Create a table. Here, the radius is specified as 10 units.

How to Draw an Arc in Excel

Final output of method 4 to Draw an Arc in Excel


Practice Section

Practice here.

practice section to draw a circle in excel with specific radius


Download Practice Workbook

 


Related Articles


<< Go Back to Circle in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Zahid Hasan
Zahid Hasan

Zahid Hassan, BSc, Industrial and Production Engineering, Bangladesh University of Engineering and Technology, has worked with Exceldmy for 1.5 years. He has written 95+ articles for Exceldemy. He has worked as an Excel & VBA Content Developer. He also worked as a VBA Developer for the Template team. Currently, he is working as a Junior Software Developer for the Excel Add-in project. He is interested in Software Development, Python, VBA, VB.NET, and Data Science, expanding his expertise in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo