Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • OneDrive
      • Google Docs
      • Google Sheets
      • Google Drive
    • Email
      • Gmail
      • Outlook
      • Emal Etiquette
    • Office Etiquette
    • Productivity
    Inside The Web
    Home»Office»Excel»How to Draw a Circle in Excel

    How to Draw a Circle in Excel

    Nisha GurungBy Nisha GurungJune 28, 2023 Excel 5 Mins Read

    While a circle may seem just a basic shape, it can serve many purposes in Excel. For Instance, you could draw circles to highlight cell values in your sheet. Or maybe use circles to create decision trees, progress bars, circle graphs, and many more. Depending on your need, you could either draw a shape or use the pre-built circle designs. 

    Draw Shapes

    Firstly, you could draw a circle from the Shapes icon in Excel. This method is for users who just want a basic circle shape. It can be useful to highlight the cell values with a circle, create chance nodes for the decision tree, build flowchart diagrams, etc. 

    Inserting shapes in Excel is pretty easy. Here, you just need to select a circle shape and draw the shape just like in the Paint program.

    1. On your worksheet, head to Insert Tab.
    2. From the Illustrations section, click on Shapes.
      From the Illustrations section, click on Shapes
    3. Under Basic Shapes, click on Oval shape. (For Flowchart diagrams, click on Flowchart: Connector shape under the Flowchart category)
      Under Basic Shapes, click on Oval shape
    4. Then, using the Plus cursor, draw a Circular shape on your sheet.
      using the Plus cursor, draw a Circular shape on your sheet
    5. To edit the shape, select the Circle and go to Shape Format.
      select the Circle and go to Shape Format
    6. Change Shape Styles, Size, Shape Oultine, Shape Fill, and many more. Here, to highlight the cell value, we set the Circle to No Fill in Shape Fill. Then, picked a Red color for the Shape Outline.
      we set the Circle to No Fill in Shape Fill
    NOTE: If you want to create a number of circle shapes of the same size, simply select the circle. Then, enter the Ctrl + D keys to duplicate the circle. This way you don’t have to keep drawing circles and resizing them.

    Insert SmartArt

    SmartArt shapes are mostly used to illustrate the relationship and process in a figure. Here, you can find several in-built designs of circles grouped together. Also, when you select a design, a short description of the figure appears at the bottom. Choose and insert one of the designs. 

    1. On your Excel worksheet, go to Insert Tab.
    2. From the Illustrations group, click on SmartArt.
      From the illustrations group, click on SmartArt
    3. On Choose a SmartArt Graphic window, browse through each category on the left and pick a Circle Design. Here, we selected the Interconnected Rings design from the Relationship category.
      On Choose a SmartArt Graphic window, pick a Circle Design
    4. Click OK to insert the circle.
    5. To modify the design, select the Shape and head to the SmartArt Design tab.
       select the Shape and head to the SmartArt Design tab
    6. To format Shape, navigate to Format Tab while the circle is still selected.
       To format Shape, navigate to Format Tab

    Insert Doughnut/Pie Chart

    For more advanced circle shapes, you can insert Excel charts as required. Excel has Doughnut, 2-D and 3-D Pie Charts. As an example, here, we will add a doughnut chart to create a progress bar.

    1. Firstly, select the Completed and Remaining data on your sheet.
    2. Navigate to Insert Tab. From Charts section, select Pie-Chart and click on Doughnut Chart.
      From Charts section, select Pie-Chart and click on Doughnut Chart
    3. Click on the Doughnut Chart twice to bring up the Format Chart Area menu. Go to each Fill & Line, Effects, and Size & Properties menu to edit the chart.
      Click on the Doughnut Chart twice to bring up the Format Chart Area

    Insert Scatter Chart

    Sometimes, you may have to create a circle graph in Excel out of the Angle and Radius. We will be using a Scatter Chart to represent the value of XY coordinates. Here, your data must have a total 360-degree angle in order to form a circle in the Scatter diagram. 

    We will first find the values of X and Y. Then, plot a scatter chart. In case you already have all the required data, you can directly begin with Step 2.

    Step 1: Find the Values of X and Y

    There’s a formula to input the values of angles instead of entering them one by one. For this, start with a 0 value in a new cell. Then, enter 15 in the next cell. Now, in the third cell, use the formula in the box. Extend the Flash-fill handle until you get the 360 value. 

    =A8 + $A$8

    Now, you have all angle in Column A. Let’s suppose, we have 10 as Radius. To find the value of X, we will use the COS and RADIANS functions nested together. Enter the formula as

    =D7*COS(RADIANS(A7))

    Here, the RADIANS(A7) formula first returns a 0-degree angle as radians. Then, the COS function returns the cosine of an angle which is 1. Finally, the result is multiplied by the value of Radius in cell D7 and returns 10 as an output. Use Flash-fill handle for other cells too.

    Now, to find out the value of Y, we will use the SIN and RANDIANS functions. Enter the formula mentioned in the box below.

    =D7*(SIN(RADIANS(A7)))

    Firstly, the RADIANS function returns the degree of A7 cells as radians. Then, the SIN function returns the angle to Sine and returns 0 according to our value. Finally, when the radius multiplies the 0 value, you will get 0. Drag the Flash-Fill handle to fill in the rest of the value of Y.

    Step 2: Plot Scatter Chart

    1. On your sheet, select the X and Y values. 
    2. Head to Insert Tab and hover over the Chart group.
      Head to Insert Tab and hover over the Chart group
    3. Select Scatter > Scatter with Smooth Lines.
      Select Scatter-Scatter with Smooth Lines
    4. You’ll have a circular scatter chart on your sheet.
      Insert Scatter Chart
    Excel Basics Excel Functions Formula
    Nisha Gurung

      As a Business Student, Nisha first used Excel to outline data trends for her college projects. Later, she started exploring basic Excel functions when she realized it is a powerful tool for all businesses today. Nisha believes she can relate to many of the issues users face when starting their Excel Journey. She uses this knowledge and experience to curate contents that are fit for all types of Excel users. Apart from writing, she enjoys reading books and traveling.

      Related Posts

      Excel By Nisha Gurung

      How to Compare Two Columns in Excel Using VLOOKUP

      Excel By Nisha Gurung

      How to Share Excel Files with Multiple Users

      Excel By Nisha Gurung

      How to Filter Based on a List in Excel

      Add A Comment
      Table of ContentsToggle Table of ContentToggle
      • Draw Shapes
      • Insert SmartArt
      • Insert Doughnut/Pie Chart
      • Insert Scatter Chart
        • Step 1: Find the Values of X and Y
        • Step 2: Plot Scatter Chart
      • Home
      • About Us
      • Privacy Policy
      © 2025 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.