If an Excel chart will not resize or keeps changing size when worksheet cells change, select the chart and adjust its object-position setting. In Excel for Microsoft 365 on Windows, right-click the chart, choose Format Chart Area, open Size & Properties, and under Properties choose Move but don’t size with cells, Move and size with cells, or Don’t move or size with cells, depending on the result you want.
Why an Excel chart changes size
An embedded chart is a floating object placed over worksheet cells. Excel can anchor that object to the grid in different ways. When you resize a row or column, insert or delete cells, or adjust a range of columns, the chart’s position or dimensions may change according to its property setting. This behavior is separate from the chart’s data: a chart can keep the same outer dimensions while its plotted values update, or its outer dimensions can change even when the underlying values do not.
That distinction explains many reports that a chart “won’t resize.” Sometimes the chart frame is not responding to cell changes because it is set not to move or size with cells. In other cases, the chart frame is behaving as intended, but the reader expects its plotted data range to expand automatically. Those are different problems and require different fixes.
A chart placed on a worksheet is also different from a chart sheet. An embedded chart sits on top of cells and can be positioned relative to them. A chart sheet occupies its own sheet, so worksheet row and column sizing does not control its dimensions in the same way.
What the three Properties settings mean
Excel’s object-position settings determine how an embedded chart responds to changes in the cells behind it:
- Move and size with cells: The chart moves when its associated cells move, and its width or height changes when the cells beneath it are resized. This can keep a chart aligned with a dashboard area, but resizing columns may stretch or compress it.
- Move but don’t size with cells: The chart follows the cells when rows or columns are moved, but its own dimensions remain fixed. This is often a useful choice when you want the chart to stay near its data without becoming distorted as column widths change.
- Don’t move or size with cells: The chart keeps its position and dimensions when worksheet cells are resized or shifted. This can be useful for a page-like dashboard layout, although the chart may overlap different cells after you reorganize the sheet.
These choices control how the chart object relates to the grid; they do not lock the chart against deliberate resizing. You can still drag its handles or enter a new height and width. They also do not prevent chart contents, such as axis labels or the plotted series, from changing when the source data changes.
Set a chart to keep its dimensions
To keep the chart’s width and height unchanged when you adjust worksheet rows or columns, use Move but don’t size with cells or Don’t move or size with cells. Choose between them based on whether the chart should travel with its location in the sheet.
- Click the chart’s border so the whole chart is selected, rather than an individual title, legend, axis, or data series.
- Right-click the chart border and select Format Chart Area. If you clicked a chart element instead, the pane may be titled for that element; click the chart area or border to select the overall object.
- In the Format Chart Area pane, select Size & Properties. In the pane’s icon row, this is the section for size and object properties.
- Expand Properties and choose Move but don’t size with cells to preserve the dimensions while allowing the chart to follow cells, or choose Don’t move or size with cells to keep both its location and dimensions fixed.
Names and pane layout can vary slightly between Excel releases. In Excel for Mac, select the chart and open its formatting pane, then look under the size and properties options for the object-position choices. Excel for the web has more limited chart-formatting controls than the desktop app; if the relevant property is unavailable, open the workbook in the Excel desktop application.
Resize the chart itself manually
If you want to set a particular chart size, select the chart’s outer border and drag one of its corner handles. A corner handle changes height and width together while preserving the general proportions more naturally than dragging a side handle. A side handle changes only the dimension associated with that side, which can make a chart appear unusually wide or tall.
For a measured size in Excel for Windows, select the chart and use the Chart Format tab’s Size group to enter a height and width. If the tab is not visible, first select the chart. Depending on the ribbon layout, the controls may be grouped under a size section on the chart formatting tab. You can also open Format Chart Area and use the size controls in the pane. On Mac, select the chart and use the available chart-formatting size controls; the ribbon and pane arrangement may differ.
To reposition a chart without changing its size, drag from its border rather than from a handle. When the chart is selected, handles around the edge indicate that dragging them will change the object’s dimensions. If you are accidentally moving a chart element instead of the whole chart, press Escape, click the outer chart border, and try again.
When the chart’s data changes but its size does not
A chart does not ordinarily grow taller or wider just because you add more values to its source data. Its frame is a separate object; Excel may update the series, axes, or labels inside that frame while leaving the outside dimensions alone. If you add rows and expect the chart to include them, check the chart’s source range rather than its object-position setting.
One practical option is to base the chart on an Excel Table. When you add data directly below a table, the table normally expands, and charts based on that table can include the added records. Confirm that the chart’s data source refers to the table or its relevant columns, and check the chart after adding a row. A chart based on a fixed cell range may not include rows entered outside that range; edit the chart’s data source or expand the range if needed.
For example, suppose a monthly sales chart uses rows 2 through 13 for January to December. Entering January of the next year in row 14 will not necessarily add it to a chart whose source stops at row 13. Making the chart larger will not solve that source-range issue. Conversely, expanding the source range can add a month to the plot without changing the chart’s physical width or height.
Common reasons resizing appears broken
- The wrong object is selected. A selected title or legend can be formatted independently, but it is not the whole chart. Click the chart’s outer border to resize the chart object.
- The object is on a chart sheet. Cell-based positioning options apply to embedded objects on worksheets. A chart sheet has its own layout, so adjust the chart sheet or move the chart to a worksheet if it needs to sit among cells.
- Worksheet protection is enabled. Protection can restrict editing objects, depending on the protection options. Review the sheet’s protection settings or ask the workbook owner to allow object editing; do not assume the chart is defective.
- The chart is grouped or overlapped. Another shape may cover its handles, or the chart may be part of a group. Use the Selection Pane, available from the Home tab’s Find & Select controls, to locate and select the intended object.
- Cell changes are driving the result. If the chart changes after adjusting columns, inspect its Properties setting. If its dimensions stay fixed but it no longer lines up with the cells, choose a movement option that matches the worksheet layout.
- The chart’s internal layout is changing. A longer axis label, a new legend entry, or a different value range can change how content fits inside the chart, even if the outside frame is the same. Check the chart border separately from its labels and plot area.
Choose the right setting for a worksheet layout
The best setting depends on what the chart should do when the worksheet changes. For a report with carefully aligned panels, Don’t move or size with cells helps preserve a fixed dashboard arrangement while you adjust data columns elsewhere. The trade-off is that inserting or deleting rows can leave the chart floating over a different part of the sheet.
For a chart that should remain beside its data as rows or columns shift, but should not distort, Move but don’t size with cells is usually a sensible starting point. For a chart intended to fit exactly within a block of cells—such as a small chart in each row of a worksheet—Move and size with cells may be more appropriate. Test the setting with the kinds of edits you actually make, especially if the sheet uses merged cells, frequent row insertions, or substantial column-width changes.
For printed reports, also check the print area and page scaling. A chart may have the intended on-screen dimensions but look smaller or larger on a printed page because Excel scales the worksheet to fit paper. Review File > Print and the page layout settings before changing the chart’s object size to compensate for print scaling.
Frequently Asked Questions
Why does my Excel chart change size when I resize columns?
Its object property is likely set to Move and size with cells. Select the chart, open Format Chart Area > Size & Properties > Properties, and choose a setting that does not size the chart with cells.
How do I stop an Excel chart from moving when I insert rows?
Set the chart to Don’t move or size with cells if it must stay in the same sheet position. If it should move with nearby content but retain its dimensions, choose Move but don’t size with cells.
Why doesn’t my Excel chart include newly added rows?
The chart may use a fixed source range that ends before the new rows. Check the chart’s data source and expand it, or use an Excel Table as the source so new table rows can be included.
Can I lock an Excel chart to an exact width and height?
You can enter chart dimensions through the chart formatting size controls and choose a property that prevents cell resizing from changing those dimensions. The chart remains manually resizable unless workbook protection or other restrictions prevent editing objects.
Why can’t I select or resize my chart?
Check that you are clicking the chart’s border, not a cell or an internal chart element. Sheet protection, an overlapping object, or a grouped selection can also interfere; try the Selection Pane or review the worksheet’s protection settings.
Related
- What Column Number Is V in Excel? Find It in Seconds
- How to Combine Two Cells in Excel and Keep Both Values
- Column J Number in Excel: How to Find and Use It Easily
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Balance Graph in Physics: Meaning and ExamplesIn physics, a “balance graph” is not one universally defined type of graph; the phrase usually refers either…
- Power Trendline in Excel: How to Add and InterpretTo add a power trendline in Excel for Microsoft 365 on Windows, select an XY (Scatter) chart, then…
- Excel Histogram Analysis: Create and Interpret DataTo analyze a distribution in Excel for Microsoft 365 on Windows, select a column of numeric observations, choose…
- Excel Graph Axis Range: How to Set Minimum and MaximumTo change an Excel graph’s axis range, select the chart axis, right-click it, choose Format Axis, and enter…
- Clustered Stack Column Chart in Excel: How to Make OneExcel does not offer a chart type named Clustered Stacked Column, but you can create the same visual…
- Excel Chart Elements: What They Are and How to Use ThemExcel chart elements are the visual parts that explain, organize, or add detail to a chart, such as…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.