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.

- On your worksheet, head to
**Insert**Tab. - From the Illustrations section, click on
**Shapes**. - Under Basic Shapes, click on
**Oval**shape. (For Flowchart diagrams, click on**Flowchart: Connector shape**under the Flowchart category) - Then, using the Plus cursor, draw a
**Circular shape**on your sheet. - To edit the shape, select the
**Circle**and go to**Shape Format**. - 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.

**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.

- On your Excel worksheet, go to
**Insert**Tab. - From the Illustrations group, click on
**SmartArt**. - 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. - Click
**OK**to insert the circle. - To modify the design, select the
**Shape**and head to the**SmartArt Design**tab.

- To format Shape, navigate to
**Format**Tab while the circle is still selected.

## 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.

- Firstly, select the
**Completed**and**Remaining**data on your sheet. - Navigate to
**Insert**Tab. From Charts section, select**Pie-Chart**and click on**Doughnut Chart**. - 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.

## 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

- On your sheet, select the
**X and Y**values. - Head to
**Insert**Tab and hover over the**Chart**group. - Select
**Scatter**>**Scatter with Smooth Lines.** - You’ll have a circular scatter chart on your sheet.