How to Create a Concentric Circle Diagram in Excel Fast

How-to basics · Updated November 21, 2026

To make a concentric circle diagram in Excel, insert several oval shapes, size each one smaller than the last, and use the alignment tools to give them the same center. Add fills, outlines, and labels to explain the layers. This creates a visual diagram directly on a worksheet; it is not a chart linked to data, so you can position and format each circle freely.

Concentric circles work well for showing levels, nested groups, priority zones, or steps moving outward from a central idea. Before you start, decide what each circle represents and whether you want filled bands or simple outlines. A quick sketch on paper can help you choose the number of layers and plan where labels will fit.

What You’ll Need

  • Microsoft Excel for Microsoft 365 on Windows, with a blank worksheet or a worksheet where you can place the diagram.
  • A short list of circle labels, ordered from the innermost idea to the outermost layer.
  • A rough idea of the colors and overall size you want. You do not need formulas or source data to make a diagram with shapes.

Step-by-Step

  1. Plan the number and meaning of the circles. Write down the central topic and each surrounding level in order. For example, a customer experience diagram might have Customer at the center, followed by Service, Operations, and Business context. Decide whether each circle will be a separate filled zone or just a boundary line. Use only as many layers as you can label clearly; too many narrow bands become difficult to read.
  2. Prepare a clear workspace. Open the worksheet and choose an area with enough room around the diagram for labels and a title. If the worksheet contains data, use a blank region or add a new sheet with the plus button beside the sheet tabs. You can hide gridlines for a cleaner design by choosing View > Show and clearing the Gridlines checkbox. Gridlines are only a worksheet viewing aid; hiding them does not change the shapes.
  3. Insert the largest circle. Choose Insert > Shapes, then select the oval shape from the basic shapes. Click and drag on the worksheet to draw it. Hold Shift while dragging to constrain the oval to a circle. If you already drew an oval, select it and use the sizing handles to make it circular; the Shape Format size controls can also set the same height and width. Make this first circle large enough to contain all the planned layers and labels.
  4. Set the outer circle’s appearance. With the outer circle selected, open Shape Format. Choose Shape Fill to select a color, or choose No Fill if you want outline-only circles. Choose Shape Outline to set a line color and, if needed, use Weight to make the boundary easier to see. For a filled diagram, a light outer color is often easier to build on because smaller circles will cover its center. Keep the outline visible if the edge needs to stand out.
  5. Create the smaller circles. Select the outer circle and copy it with Ctrl+C, then paste with Ctrl+V. Resize the pasted copy by dragging a corner sizing handle inward. Repeat for each additional layer, making each copy smaller than the one before it. Resizing a copy preserves its circular proportions when you drag a corner handle; avoid dragging a side handle, which changes only one dimension and turns the circle into an oval. If you need a particularly precise size, select a circle and enter equal Height and Width values on Shape Format.
  6. Center all circles precisely. Hold Ctrl and select each circle, clicking its visible outline. With all of them selected, choose Shape Format > Align > Align Center, then choose Shape Format > Align > Align Middle. These commands line up the horizontal and vertical centers of the selected shapes. If you cannot select a circle because another shape covers it, open Home > Find & Select > Selection Pane and select the shapes by their listed names. You can rename them there to make later editing easier.
  7. Choose how the rings should look. For distinct filled bands, use different fill colors on the nested circles. The smaller circles sit on top of larger ones, so each one covers the center of the circle below it and leaves a visible band around its edge. For an outline-only design, set every circle to Shape Fill > No Fill and use contrasting outlines. For softer filled colors, select a circle, open the Format Shape pane, and adjust Fill Transparency. Make sure text remains readable against the colors you choose.
  8. Add labels and a title. To label a circle, right-click it and choose Add Text, then type the label. This places text inside the shape, which is convenient for a short central label. For labels that need more space, choose Insert > Text > Text Box and draw a text box beside the relevant ring. Use concise wording and a consistent font. If you put a label on a filled band, position it in the visible part of that band rather than in the smaller circle covering it. Add a separate text box above the diagram for a descriptive title if needed.
  9. Check the stacking order and finish the layout. If a circle or label appears behind another object, select it and use Shape Format > Bring Forward or Send Backward to adjust its order. In a filled diagram, the largest circle should be at the back and the smallest at the front. Select the diagram’s shapes and text boxes when you need to move the whole composition; after finishing, you can choose Shape Format > Group > Group to keep selected objects together. Grouping is optional and may make individual edits less convenient.
  10. Review the result at normal size and in print preview. Zoom out to check that the circles look balanced and the labels can still be read. Choose File > Print to inspect how the diagram will fit on a page. If it is clipped or too small, change the print orientation or scaling in the print settings, or resize and reposition the diagram on the sheet. Save the workbook after the layout is complete.

Common Mistakes

Drawing ovals instead of circles: An oval can look almost circular while still making the diagram feel uneven. Hold Shift when drawing, or set matching height and width values for every shape. Also resize from a corner rather than a side handle.

Centering by eye: Small differences in position become obvious when several outlines are visible. Select all the circles and use both Align Center and Align Middle. Aligning only one way fixes horizontal or vertical placement, not both.

Using colors with too little contrast: Similar fills can make adjacent rings run together, while very dark fills can make labels hard to read. Choose colors that remain distinct and check text contrast at the size people will view the diagram.

Adding too many labels inside narrow bands: The visible part of each ring gets thinner as the circles become closer in size. Use short labels, place longer descriptions in separate text boxes, or reduce the number of layers rather than shrinking the text until it becomes unreadable.

Forgetting that shapes are not data-linked: A diagram made with oval shapes will not automatically update when worksheet values change. If the content or number of layers changes, edit the shapes yourself. Use this approach for a flexible illustration, not for a chart that must recalculate from data.

Tips

  • Keep the center and outermost circle visually distinct so the viewer can identify the hierarchy immediately.
  • Use a consistent gap between circle sizes. Uneven band widths can be useful when they have meaning, but otherwise they may look accidental.
  • Use the Selection Pane to select, rename, hide, or reorder objects when the circles overlap. Names such as Outer ring and Core make complex diagrams easier to maintain.
  • Leave enough white space around the diagram for a title, explanatory note, or legend. Avoid placing labels directly on a circle boundary.
  • If you want a transparent background, use Shape Fill > No Fill for each circle and keep a visible Shape Outline. No Fill is different from a white fill, which can cover objects behind the shape.
  • For future editing, keep a copy of the worksheet before flattening or exporting the diagram as an image. The original shapes are easier to revise than a single picture.

Troubleshooting

The shapes are not centered after resizing. Select all the circles again and apply Shape Format > Align > Align Center and Align Middle. Make sure the alignment commands apply to the selected objects, not just the currently active circle. If selection is difficult, use Home > Find & Select > Selection Pane to select each object by name.

A circle becomes stretched. Undo the last resize with Ctrl+Z, or select the shape and set its Height and Width to the same value on Shape Format. When dragging a handle, use a corner handle. If you are using Excel for Mac, the same general shape and alignment controls are available, though the ribbon layout can differ slightly; use the Shape Format tab when a shape is selected. Keyboard equivalents for copy and paste are Command+C and Command+V on Mac.

The inner circle hides too much of the outer ring. Make the inner circle smaller, or increase the outer circle’s size to create a wider band. If the goal is to show only boundaries and no filled zones, set the circles to No Fill instead of using opaque fills. For semi-transparent fills, adjust transparency in the Format Shape pane and inspect the result against every underlying color.

A label disappears behind a circle or is hard to read. Use the Selection Pane to select the text box, then choose Shape Format > Bring Forward or Bring to Front as appropriate. If text is inside a circle, change the fill or font color, or move the text to a text box placed on a clearer area. Check that labels are not clipped by the shape’s text margins.

The diagram looks fine on screen but prints badly. Open File > Print and check the preview. Set the page orientation or scaling so the full diagram fits, and make sure the selected print area includes the shapes if you have set a print area. If the preview is too small, use a larger paper size or place the diagram on its own worksheet before printing.

Frequently Asked Questions

Can Excel make a concentric circle diagram automatically?
Excel does not have a dedicated concentric-circle diagram command. Insert > Shapes lets you build one manually with oval shapes, which gives you control over the sizes, fills, outlines, and labels. SmartArt may suit some hierarchy diagrams, but it does not provide the same free-form circle layout.

How do I make sure the circles have exactly the same center?
Select all the circles and use Shape Format > Align > Align Center, followed by Align Middle. This aligns their centers horizontally and vertically even if their diameters differ.

Can I make the circles transparent?
Yes. Select a circle, open the Format Shape pane, and set a fill transparency value. You can also choose Shape Fill > No Fill when you want no interior fill at all. Use outlines so the boundaries remain visible.

How many circles should the diagram have?
There is no fixed limit, but readability is more important than fitting in every possible category. Start with the number of meaningful levels in your idea. If the rings become too thin for labels or hard to distinguish, reduce the count or put descriptions outside the circles.

Can the circles update when my data changes?
Not when they are ordinary shapes. Their size, position, and text are edited manually. If you need a visual that responds to changing data, consider a chart or another data-driven visualization and confirm that it represents your categories accurately.

Can I move the finished diagram without separating its parts?
Yes. Select the circles and any text boxes that belong together, then choose Shape Format > Group > Group. You can move or resize the grouped composition as one object. Ungroup it later if you need to adjust individual circles or labels.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.