To make a circle with four segments in Excel, enter four categories and four positive values, select the data, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. Use four equal values for equal quarters, or different values for slices sized in proportion to the data. A pie chart is the simplest way to create a clean, editable four-part circle.
What You’ll Need
- Excel for Microsoft 365 on Windows, or an Excel version with pie charts.
- A worksheet with four category names and one positive number for each category.
- Optional: the labels, colors, and title you want readers to see.
Step-by-Step
- Set up four rows of data. In a blank worksheet, type a heading such as Segment in cell A1 and Value in B1. Enter four category names in A2:A5 and their corresponding numbers in B2:B5. For an equal four-part circle, enter 25 in each value cell. The numbers add to 100, so each slice will be one quarter of the pie. The numbers do not have to add to 100; Excel calculates each slice as a proportion of the total. For example, values of 40, 30, 20, and 10 produce slices of 40%, 30%, 20%, and 10%.
- Select only the category and value cells. Drag from A1 through B5 so the heading and all four rows are selected. Do not include a total row below the data. If the headings are not adjacent to the values, select the two-column table together before inserting the chart. Excel uses the category names as slice labels and the numbers to determine slice sizes.
- Insert a 2-D pie chart. On the ribbon, select Insert > Insert Pie or Doughnut Chart, then choose 2-D Pie. The chart appears on the worksheet. If your ribbon is condensed, look for the pie-chart icon in the Charts group or open the chart-type menu under Insert. Choose the regular 2-D Pie option rather than a doughnut if you want a solid circle with no hole in the center.
- Check that the chart has four slices. With four valid, positive values in the selected range, the chart should have four wedges. If you see too many, too few, or an unexpected blank slice, check that the selected range contains exactly four data rows and that no total or extra category was included. A value of zero has no visible area, so it will not look like a normal segment. Negative values are not suitable for a pie chart.
- Make the circle large and easy to read. Click the chart once to select it, then drag a corner sizing handle to enlarge it. To keep the pie looking round rather than squeezed, make the chart area roughly as wide as it is tall. Drag from a corner rather than a middle handle so the proportions are less likely to become distorted. Leave room around the chart for its title, labels, or legend.
- Add a descriptive title. Select the chart, then choose Chart Design > Add Chart Element > Chart Title > Above Chart. Click the title placeholder and type a short description, such as Quarterly Budget Split. A title explains what the circle represents; it is especially useful if you plan to copy the chart into a report or presentation.
- Show category names or percentages. Select the chart and choose Chart Design > Add Chart Element > Data Labels > Best Fit. To choose exactly what appears, right-click a data label and select Format Data Labels. In the formatting pane, select Category Name to show the four segment names and Percentage to show each slice’s share. Clear Value if you do not want the raw numbers displayed. You can reposition labels using the label-position options in the same pane.
- Choose colors that distinguish the segments. Select the chart and use Chart Design > Change Colors to apply a coordinated palette. If you need to change just one wedge, click the pie once to select the series, then click the wedge again to select that individual data point. Right-click it and choose Format Data Point; in the pane, use Fill & Line to choose a solid fill. Use colors with clear contrast, and do not rely on color alone if the chart needs to be accessible or printed in grayscale.
- Finish and check the result. Confirm the chart shows exactly four visible wedges, that each label belongs to the intended category, and that the numbers are represented in the expected proportions. Click outside the chart to see how it looks on the worksheet. If you change a value in the source table later, the chart updates automatically as long as the cell remains inside the chart’s data range.
Excel for Mac and Excel for the web also support pie charts. Select the data and use the Insert tab to find the pie-chart options; the precise grouping or icon placement can vary with the ribbon layout. Chart Design and formatting controls may appear only after you select the chart. If an option is not immediately visible, widen the Excel window or open the relevant ribbon menu.
Common Mistakes
Including a total as a fifth category: A pie chart treats every selected data row as a slice. If you add a total row, Excel may create an unwanted fifth wedge. Select the four category rows and their values, but leave the total out.
Expecting four equal slices from unequal numbers: Excel sizes each segment according to its share of the total. Values of 40, 30, 20, and 10 will not create four equal quarters. Use the same positive value in each of the four rows when equal segments are the goal.
Choosing the wrong chart type: A doughnut chart has a hole in the middle, and a 3-D pie can make slice sizes harder to compare. Choose 2-D Pie for a straightforward solid circle. Avoid exploding or separating slices unless you specifically want gaps between them.
Showing raw values when percentages are needed: Data labels can show values, category names, and percentages. Check the Format Data Labels pane rather than assuming the default label is the one you want. For a simple four-part graphic, category names and percentages are often clearer than values alone.
Stretching the chart: A pie can look oval if the chart area is much wider than it is tall. Resize from a corner and keep the chart area close to square. Also make sure labels are not clipped at the edge of the chart.
Tips
Use meaningful category names in the source table before inserting the chart. Names such as Housing, Food, Travel, and Other make the legend or data labels useful; labels such as Item 1 and Item 2 force readers to look elsewhere for an explanation. Keep names concise enough to fit beside the wedges.
For a circle split into four identical quarters, set all four values to the same positive number. They can all be 1, 25, or another equal value; the proportions will remain equal. Using 25 in each row is convenient when you want the displayed percentages to be easy to understand, but Excel calculates the share from the total rather than interpreting 25 as a special setting.
Use a legend when labels beside small slices would overlap. Select the chart, then choose Chart Design > Add Chart Element > Legend and pick a position. If there is enough room, direct labels can be quicker to read because each name appears next to its slice. Preview the chart at the size it will actually be used.
Keep the source table near the chart, or place it on a clearly named worksheet, so you can update the values later. If you paste the chart into another Office app, use the paste option that keeps it linked to the workbook only if you want later edits to the source data to update the pasted chart. Otherwise, paste a static picture when the chart should not change.
Troubleshooting
The chart has the wrong number of slices: Right-click the chart and choose Select Data to inspect its source range. Check that the range includes the four intended names and values, and excludes headings or totals that should not be plotted. If the chart is based on the wrong cells, select the correct range and insert a new pie chart, or adjust the chart data range in the Select Data dialog.
The chart looks like one solid color or a single wedge: Look at the values in the selected range. If only one row has a positive number and the others are blank or zero, only that row contributes visible area. Enter a positive value for each category. Also check that the chart references the value column rather than a column of repeated text.
Percentages do not match what you expected: Excel calculates each percentage by dividing a slice’s value by the sum of the plotted values. Verify the four values and make sure no extra row is included in the chart range. For example, values 40, 30, 20, and 10 total 100, so they display as 40%, 30%, 20%, and 10%.
Labels are missing or unreadable: Select the chart and add Data Labels from Chart Design > Add Chart Element. Then open Format Data Labels to choose the information and position. If names or numbers collide, enlarge the chart, shorten the category names, move the labels, or use a legend instead.
The pie is oval, clipped, or too small: Resize the chart using a corner handle and make its width and height closer to equal. If text is cut off, enlarge the chart area or choose another label position. A crowded chart may need a shorter title or a legend placed below or beside the pie.
Frequently Asked Questions
How do I make four equal segments in an Excel circle?
Enter four positive values that are identical, such as 25, 25, 25, and 25, then insert a 2-D Pie chart. Excel will give each category 25% of the circle.
Do the four values have to add up to 100?
No. Excel calculates each wedge as its value divided by the sum of the values in the chart. Values of 1, 1, 1, and 1 make equal quarters, just as values of 25, 25, 25, and 25 do.
Can I make the four segments different sizes?
Yes. Enter the numbers that represent the relative sizes you want. For example, 40, 30, 20, and 10 create slices of 40%, 30%, 20%, and 10%. The chart displays proportions, not fixed angles.
Can I label each segment with its name and percentage?
Yes. Add data labels, right-click a label, and open Format Data Labels. Select Category Name and Percentage. If the labels overlap, try another label position or use a legend for the category names.
Can I make a four-segment circle without a chart?
You can draw a circle and use shapes or lines, but it is harder to keep the sections evenly divided and update them. A pie chart is usually the practical choice when you want four wedges that represent equal or changing values. Use shapes only when the diagram must be decorative and unrelated to data.
Related
- Excel Slicer Formatting: Styles, Size, Layout, and Use
- Excel Slicers: What They Do and How to Use Them
- Excel Slicers: How to Create and Use Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Mail Merge in Word From Excel: Step-by-Step GuideTo mail merge in Word from an Excel file, prepare a clean list with one recipient per row,…
- Excel Text to Columns: Split Names, Dates, and Other DataIn Excel for Microsoft 365 on Windows, select the cells in one column, then choose Data > Text…
- Schedule Recurring Emails in Outlook: Your OptionsOutlook can schedule a single email, but it does not have a built-in option to send the same…
- How to Add a Header Template in WordTo add a header template in Microsoft Word, open the document, choose Insert > Header, select a built-in…
- How to Create and Print Shipping Labels in Microsoft WordIn Word for Microsoft 365 on Windows, choose Mailings > Start Mail Merge > Labels, select the label…
- Conditional Formatting Strikethrough in ExcelYes. In Excel for Microsoft 365 on Windows, you can use conditional formatting to strike through an entire…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.