To move a pie chart within its chart frame in Excel for Microsoft 365 on Windows, select the chart, click the blank space around the pie to select the plot area, then drag its border to a new position. If you mean moving the entire chart on the worksheet, drag the chart’s outer border instead.
Chart area and plot area are different
Excel charts have several selectable parts, and knowing which one you have selected is the key to moving the pie correctly. The chart area is the full chart object: it includes the background, title, legend, plot area, and other chart elements. The chart area is what you move when you want to relocate the whole chart on the sheet.
The plot area is the region where Excel draws the data. In a pie chart, it contains the pie and is the part to reposition when you want the pie to sit differently inside the chart’s outer frame. The legend and title are separate elements, so moving the plot area does not necessarily move them with the pie.
A common source of confusion is that clicking the pie itself selects the data series or an individual slice, rather than the plot area. That selection is useful for changing slice formatting, but it is not the right selection for moving the pie as a whole within the chart.
Move the pie with the mouse
Start with a chart that has enough empty space around the pie to grab the plot area. Click the chart once to activate it. Then click a blank part of the plot area, such as the open space between the pie and the chart border. When the plot area is selected, a rectangular outline with sizing handles appears around it.
- Click the chart to display its chart handles and contextual ribbon tabs.
- Click a blank area around the pie, not on a colored slice, title, or legend. Look for the outline around the plot area.
- Place the pointer on the outline between the sizing handles. When the pointer indicates that the area can be moved, drag the plot area to the desired position.
- Release the mouse and check that the pie, labels, and other plot-area contents have the spacing you want.
Dragging the middle of an edge or the outline moves the selected area. Dragging one of the small handles resizes it instead. If the pie gets larger or smaller rather than changing position, undo the action with Ctrl+Z on Windows, select the plot area again, and begin the drag from the border away from a handle.
Select the plot area from the ribbon
Clicking the correct blank space can be tricky when a pie fills most of the chart or labels cover the surrounding area. You can select the element by name instead. First click the chart, then open the Format tab under Chart Tools. In the Current Selection group, open the element dropdown and choose Plot Area. Excel highlights that part of the chart, so you can drag its border without accidentally selecting a slice.
If the ribbon is narrow, the Current Selection controls may be compressed or displayed differently. Look for the dropdown that names the currently selected chart element. Confirm that it reads Plot Area before dragging. The Format Selection command opens formatting options for the selected element, but the simplest way to reposition it is still to drag its outline directly in the chart.
This selection method is also useful when chart elements overlap. For example, a data label may sit close to the edge of the pie, leaving no obvious place to click. Choosing Plot Area from the dropdown avoids having to remove the label or alter the data just to make the plot area selectable.
Make room with sizing and chart elements
Moving the pie may not be enough if the plot area is crowded. You can resize the plot area by selecting it and dragging a corner or side handle. Resizing changes the space available to the pie; Excel may scale or reposition chart contents as the plot area changes. Try small adjustments and review the result, because aggressive resizing can make the pie too small or leave awkward gaps.
A legend can take up a substantial part of a compact chart. To change its placement, select the chart and use Chart Design > Add Chart Element > Legend, then choose a placement such as Right, Top, Left, Bottom, or None. The available space for the plot area changes when the legend is moved or removed, so Excel may adjust the pie’s layout. You may need to reposition or resize the plot area again afterward.
Data labels can also affect the appearance of a pie chart, especially when labels are outside the slices. Use Chart Design > Add Chart Element > Data Labels to choose a label placement or turn labels off. If labels overlap after moving the plot area, changing their placement can be a better fix than squeezing the pie into a smaller space. The menu choices can vary depending on the chart and the selected label options.
Why the pie may not move as expected
If dragging seems to do nothing, Excel may have selected a different chart element, or the pointer may be on a sizing handle. Check the outline and the Current Selection dropdown. A plot-area selection outlines the region around the plotted data; a selection outline around an individual slice indicates that the data point, not the plot area, is active.
Another common issue is trying to drag the chart while it is selected for editing. To move the whole chart, point to its outside border until the move pointer appears, then drag. To move the pie inside it, select Plot Area first and drag that area. If Excel instead selects a worksheet cell, click the chart again before trying to move either element.
Excel also maintains the chart’s layout as you change its size, legend, title, and labels. A plot area that fits neatly in one chart size may not keep the same spacing after you resize the outer chart. If the pie shifts after changing the chart dimensions, select the plot area and adjust it again. That is a layout response, not a change to the underlying values or the order of the slices.
Move the full chart on the worksheet
When the goal is to place the whole chart beside a table or on another part of the sheet, select the chart’s outer edge and drag. Avoid grabbing the plot-area outline, title, legend, or a slice, because each has its own selection behavior. You can also cut and paste the chart to another location, but dragging the outer border is usually the direct option when the chart should remain on the same worksheet.
To put a chart on its own sheet, select it and use Chart Design > Move Chart. Choose New sheet to create a chart sheet, or choose Object in and select a worksheet to place it on an existing sheet. This changes where the entire chart object lives; it does not reposition the pie inside its chart area.
Moving or resizing the chart does not change the source data. If the slices themselves represent the wrong categories or values, edit the chart’s data source rather than adjusting the plot area. Keeping those tasks separate helps avoid using layout changes to compensate for an incorrect chart selection.
Excel for Mac and Excel for the web
In Excel for Mac, the same basic distinction applies: select the chart, select its plot area, and drag the outline to reposition it. The contextual chart tabs and controls may be arranged differently from Windows, so use the ribbon’s chart-formatting controls to identify the selected element if clicking the plot area is difficult. On Mac, the common undo shortcut is Command+Z rather than Ctrl+Z.
Excel for the web supports editing many chart elements, but the available chart controls and selection behavior can differ from the desktop app and may change with the web interface. If you cannot select or position the plot area precisely in your browser, open the workbook in the Excel desktop app and make the adjustment there. The underlying chart and data remain in the workbook; this is a difference in editing controls, not a separate kind of pie chart.
Frequently Asked Questions
How do I move a pie chart without moving the whole chart?
Select the chart’s plot area, then drag its outline. Do not drag the outer chart border, which moves the full chart object on the worksheet.
Why does Excel resize my pie when I try to move it?
You probably dragged a sizing handle on the plot-area outline. Undo the change, then drag from the middle of an edge or another part of the outline between handles.
Can I move the pie to the left of its legend?
Yes. Select and drag the plot area toward the left, and consider moving the legend with Chart Design > Add Chart Element > Legend. The legend’s position affects the space available to the pie.
Can I move one slice separately?
Yes, but that is a different action. Select the pie series and then select the individual slice before dragging it outward to create an exploded slice. It does not move the entire pie within the plot area.
Does moving the plot area change the chart’s data?
No. Moving or resizing the plot area changes the chart’s layout only. To change the values or categories shown by the slices, edit the chart’s source data or data selection.
Related
- Excel Highlight Active Cell Row and Column Automatically
- Excel: How to Calculate Workdays Between Two Dates
- Excel Highlight Dates Older Than Today Automatically
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Insert an Excel Chart in CanvaTo insert an Excel chart in Canva, save the chart from Excel as a PNG image, then upload…
- Hourly Gantt Chart Template Excel: Plan by the HourYes—an hourly Gantt chart template in Excel can be built with one row per task, one column per…
- Excel Pivot Filter by Color: How to Filter the DataExcel PivotTables cannot directly filter their source records by cell fill color or font color. To filter a…
- Excel Sparklines Line Chart: How to Add and Format OneIn Excel for Microsoft 365 on Windows, select the data, choose Insert > Sparklines > Line, and specify…
- Excel Pivot Table Calculated Field: How to Add OneTo insert a calculated field in an Excel PivotTable, select the PivotTable, then choose PivotTable Analyze > Fields,…
- Excel Chart Title From Cell: Link, Format, and FixesTo link an Excel chart title to a cell, select the chart title, click the formula bar, type…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.