To make an Excel donut chart’s ring thicker, select the ring, open Format Data Series, and reduce Doughnut Hole Size. To make the entire donut larger, enlarge the chart object instead; these are different adjustments, and changing one does not substitute for the other.
What wider means in a donut chart
People asking how to make a donut chart wider may mean one of two things: they want more colored band between the outer edge and the center hole, or they want the whole chart to take up more space on the worksheet. Excel provides separate controls for those goals.
The band is thicker when the center hole is smaller relative to the chart. The Doughnut Hole Size setting controls that proportion. A lower percentage leaves less empty space in the middle and more room for the colored ring. A higher percentage makes a larger hole and a thinner ring. This changes the ring’s shape, not the chart’s overall dimensions.
If the chart looks too small on the sheet, change its width and height. That increases the chart’s footprint and the donut’s displayed size, while generally keeping the hole-to-ring proportion set by the hole-size option. You can use both adjustments: enlarge the chart and reduce the hole size if you want a larger donut with a heavier-looking band.
Make the ring thicker by reducing the hole size
In Excel for Microsoft 365 on Windows, use these steps to adjust the ring thickness:
- Click the donut chart, then click one of its colored segments so the data series is selected. If only a single segment is selected, click the ring again to select the series rather than just that data point.
- Right-click the selected ring and choose Format Data Series. The formatting pane opens at the side of the worksheet.
- In the pane, select Series Options if it is not already active. Look for Doughnut Hole Size.
- Reduce the percentage, either by typing a value in the box or using its control. For example, changing 75% to 55% makes the hole smaller and the colored band thicker.
- Click elsewhere to see the result, then adjust again if needed. The best setting depends on the chart’s displayed size and the amount of space available for labels.
The percentage describes the hole’s size relative to the chart, not a measurement in inches or pixels. A 50% setting does not mean the ring is 50% thick; it means the center opening is set to half the chart’s diameter. Excel’s available range is typically 10% through 90%. A very low value can make the chart resemble a pie chart with a tiny opening, while a very high value can leave only a narrow band.
In Excel for Mac, select the series and open Format Data Series from the contextual formatting controls or the right-click menu. The pane offers the same Doughnut Hole Size adjustment, though its appearance and ribbon layout can differ. Excel for the web has a more limited editing interface, and not every chart-formatting control is available in every build. If you cannot find the setting, open the workbook in the desktop Excel app.
Enlarge the whole chart on the worksheet
To give the entire chart more room, select its outer border rather than a colored segment. Drag a corner sizing handle outward to increase both its width and height. Dragging a middle handle changes one dimension. If you want a precise size, select the chart and use the contextual Format tab, then enter values in the Height and Width boxes in the Size group. Depending on the ribbon layout, you may need to expand the Size group to see both fields.
When resizing by hand, a corner handle is usually the easiest choice because it enlarges the chart in both directions. A very wide, short chart may leave less useful space for the circular plot or its legend. If you need the donut itself to look larger, give the chart enough height as well as width, and consider moving the legend or labels to free up room.
Chart dimensions and worksheet cell dimensions are independent. Increasing a chart’s width does not change the column widths beneath it, and widening a column does not necessarily resize a chart unless the chart’s positioning properties are set to move or size with cells. If a chart must line up with a table, resize the chart object directly and use the worksheet grid as a visual guide.
Improve the chart layout after resizing
A chart can be large while its donut remains visually small if the legend, title, or data labels occupy much of the chart area. After resizing, check whether Excel has arranged these elements in a way that leaves enough space for the ring. You can select and reposition a legend or title, or remove an element that is not helping readers understand the data.
To change chart elements, select the chart and use the Chart Design tab’s chart-element controls, or select an element directly and format it. The exact controls shown can vary with the ribbon layout and chart selection. For data labels, choose a position that does not collide with neighboring labels. A thicker ring can make labels easier to place, but it cannot prevent overlap when there are many small categories.
- Keep the chart close to square when you want the donut to read as a circular graphic. A much wider or taller chart can make the plot area feel cramped, even if the outer chart object is large.
- Use a readable legend when category names are lengthy. A legend below the chart may suit a wide layout; one beside it may work better when the chart is tall.
- Check the chart at its final display size. Labels that look clear while zoomed in may be too small when the chart is pasted into a report or presentation.
If formatting the chart area does not seem to change the ring, verify which element is selected. Excel distinguishes the outer chart area, the plot area where the data is drawn, the series, and individual data points. Selecting the chart border is appropriate for changing its dimensions; selecting the series is necessary for the hole-size setting.
Choose a hole size that suits the data
There is no single ideal hole-size percentage. A moderate opening often provides a clear donut shape without making the colored band too thin. For a chart with only a few categories, a thicker ring can make the segments easy to see. For a chart with many categories, shrinking the hole may give the segments more visible area, but it does not solve the underlying problem of too many small slices.
Consider a chart showing five departments’ shares of a total. If the default-looking ring seems too delicate, reducing the hole size can make each segment more prominent. If one department contributes 2% and the others account for most of the total, however, that 2% segment remains small. Changing the hole size does not change any values, percentages, category order, or the relative size of the slices.
Also think about what readers need from the center. A donut’s open middle can be useful for visual breathing room or for a separately designed text callout, but Excel does not automatically make the hole a value label. If you add text over the center, make sure it stays legible and does not imply a total or metric that the chart does not actually show. Avoid shrinking the hole so much that the chart loses the visual distinction that makes it a donut.
Common problems and how to fix them
- The hole-size control is missing. Make sure you selected a data series in a doughnut chart, not the chart border, the legend, or a single label. Right-click a colored segment and open Format Data Series. If the workbook is open in Excel for the web and the option is unavailable, use desktop Excel.
- The chart got bigger, but the ring still looks thin. Resizing changes the chart’s physical footprint. Reduce Doughnut Hole Size separately to increase the band’s proportion of the chart.
- The ring got thicker, but the chart still looks small. The hole-size setting changes the proportions inside the chart, not the chart object’s width and height. Select the outer chart border and resize it.
- Only one slice seems to respond. Excel may have selected a single data point. Click the ring again or use the formatting pane’s selection controls to target the whole series, then change its series option.
- Labels overlap after making the ring thicker. Move labels, reduce unnecessary labels, or use a legend. If the chart contains many categories, consider a different chart type rather than forcing every label around the ring.
- The chart looks stretched or oddly arranged. Review both chart dimensions and element placement. Make the chart closer to square, and reposition the legend or title so the plot has room.
A thicker band can improve visibility, but it is not a way to exaggerate a category’s share: Excel still draws each segment according to its value. For a fair comparison, keep the underlying data unchanged and use hole size only as a presentation choice.
When another chart type may work better
A donut chart is most useful when the categories make up a meaningful whole and there are only a few of them. It is less effective for comparing many similar values, because readers must judge angles or arc lengths and small segments are difficult to compare precisely. If exact comparison matters, a bar chart often makes differences easier to see. For a trend over time, a line chart is usually more appropriate than a donut.
Changing to a different chart type is not the same as changing donut thickness. If the goal is simply a stronger-looking ring, keep the donut and adjust its hole size. If the chart remains hard to read after resizing and simplifying its labels, reconsider whether a circular part-to-whole chart is the clearest way to present the data.
Frequently Asked Questions
Can I make an Excel donut chart wider without changing the hole?
Yes. Select the chart’s outer border and increase its width using a sizing handle or the Format tab’s Size controls. That enlarges the chart object; use Doughnut Hole Size only when you want to change the ring-to-hole proportion.
How do I make the donut ring thicker?
Select the data series, open Format Data Series, and lower Doughnut Hole Size. A lower percentage produces a smaller center hole and a thicker band.
What is the default hole size in Excel?
The default commonly appears as 75%, but it can vary if the chart has been formatted or its style changed. Select the series and check the current value in the Format Data Series pane rather than assuming it is unchanged.
Can I set an exact donut chart width and height?
Yes. Select the chart, open the contextual Format tab, and enter dimensions in the Size group’s Width and Height fields. You can also drag a sizing handle when exact measurements are not important.
Does changing the hole size change the percentages in my chart?
No. It changes the visual opening and ring thickness, not the source values or the proportions represented by the slices. If the displayed percentages or segment sizes are wrong, check the chart’s source data and label settings instead.
Related
- Close Excel Shortcut Key for Windows and Mac
- Close Group Excel Shortcut: Close Workbooks and Rows
- Close Excel Shortcut: Windows and Mac Keys
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Double Doughnut Chart in Excel: How to Create OneTo create a double doughnut chart in Excel for Microsoft 365, put the category names in the first…
- Link Excel to Word: Keep Tables and Charts UpdatedTo link Excel data to Word, copy the cells or chart in Excel, then in Word for Microsoft…
- Does Google Sheets Have Pivot Tables? How to Use ThemYes. Google Sheets has pivot tables, which let you summarize and reorganize rows of data without changing the…
- Org Chart Template for Google SheetsTo make an org chart in Google Sheets, put each person or position in column A and that…
- How to Move the Y-Axis to the Right in ExcelTo move a chart’s vertical (Y) axis to the right in Excel for Microsoft 365 on Windows, select…
- How to Make a Linear Graph in Google SheetsTo make a linear graph in Google Sheets, put your data in columns, select the range, and choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.