Make Charts in Excel the Same Size: A Step-by-Step Guide

To make several charts the same size in Excel for Microsoft 365 on Windows, select their chart borders together, open the contextual Format tab, and enter matching Height and Width values in the Size group. Set both dimensions to the same values for every selected chart. This makes the chart objects equal in size; it does not necessarily make their plot areas, labels, or legends look identical.

What You’ll Need

An Excel workbook with the charts you want to resize, preferably embedded on the same worksheet.
The target height and width. Decide what dimensions suit your layout before selecting the charts. Excel displays dimensions in the units set by your system or Office settings, such as inches or centimeters.
Permission to edit the worksheet objects. If the sheet is protected, you may need the owner or workbook author to allow chart editing.

Step-by-Step

Save a working copy and choose your dimensions. Save the workbook before making layout changes, especially if it contains many carefully arranged charts. Decide on one height and one width, and check that the chosen size fits the sheet. For example, if the displayed units are inches, you might choose a width of 4.5 and a height of 3.0. Those values describe the outer chart objects, not the space used only by the plotted data. If your ribbon displays centimeters, enter the equivalent values in centimeters instead of mixing units.
Open the worksheet containing the charts. Click the sheet tab where the charts are placed. This method works best for embedded charts on one worksheet. If the charts are spread across several sheets, resize the charts on each sheet separately; Excel does not let you select chart objects on different worksheets at the same time. A chart on its own chart sheet also behaves differently from an embedded chart and does not sit in a normal worksheet grid layout.
Select the first chart by its outer edge. Click the chart once, aiming for its border rather than a title, axis, legend, or data series. When the chart object is selected, you should see sizing handles around its outside edge and chart-specific contextual tabs appear on the ribbon. Clicking an inner element can select only that element, so check for handles around the whole chart before continuing.
Add the other charts to the selection. On Windows, hold down Ctrl and click the outer border of each additional chart. Keep Ctrl held while you click each one, and make sure each chart shows its selection handles. On a Mac, use Command-click instead of Ctrl-click. Avoid clicking inside the plot area or dragging a handle, because those actions can select a chart component or change its size before you have a complete selection. If a chart is accidentally removed from the selection, Ctrl-click or Command-click its border again.
Use the Selection Pane if clicking the charts is awkward. Go to Home > Find & Select > Selection Pane. The pane lists objects on the active worksheet, including charts, and may show generic names such as Chart 1. Click a chart name, then hold Ctrl on Windows or Command on Mac while selecting the other chart names. Rename objects in the pane first if that will help you identify them. Close the pane only after confirming that the charts you want are selected.
Enter one height and width for the whole selection. With all target charts selected, open the contextual Format tab on the ribbon and find the Size group. Type the desired value in Height, then type the desired value in Width, pressing Enter after each entry. The selected chart objects should update to those dimensions together. In some ribbon layouts the Size group is toward the right side of the Format tab; widen the Excel window or expand the ribbon if you cannot see it. Do not use the chart title or plot-area formatting controls for this job.
Check the result and adjust placement if needed. Click a blank cell to clear the selection, then compare the charts’ outside edges. They should now have matching height and width, even if the charts contain different amounts of content. Resizing can make nearby objects overlap or leave uneven gaps, so drag charts by their borders to reposition them. If you need even spacing as well as equal dimensions, use the alignment and distribution commands on the contextual Format tab after arranging the charts in a row or column.
Repeat the same dimensions on other worksheets. Select the charts on the next sheet and enter the same Height and Width values. Keep a note of the values if you are standardizing a dashboard across multiple tabs. Afterward, save the workbook and revisit the sheets at normal zoom to make sure titles, legends, and labels remain readable.

Common Mistakes

Selecting an element instead of the chart object: A chart contains separate objects such as a legend, title, axis, and plot area. If only one of these is selected, the Size controls may resize that component rather than the complete chart. Look for handles around the chart’s outer edge before setting dimensions.

Changing only one dimension: Matching widths while leaving different heights, or the reverse, does not make the charts the same overall size. Set both Height and Width for the full selection. Also use consistent units; a value intended as centimeters will not match an inch-based value if entered without checking the displayed units.

Expecting identical chart content to fit identically: Equal outer dimensions do not guarantee equal plot-area dimensions. A chart with a long title, a large legend, or lengthy category labels may devote more room to those items and leave less room for the plotted data. This is a content-layout difference, not necessarily a sizing failure.

Dragging handles by eye: Manual resizing can leave small differences that are difficult to spot. Use the numeric Height and Width boxes for precise matching, then use dragging only to position the charts.

Confusing chart sheets with embedded charts: A chart sheet occupies its own sheet rather than floating over worksheet cells. If your chart is a chart sheet, it will not behave like a group of embedded objects selected on one grid. Consider placing a copy as an embedded chart if it needs to share a dashboard layout with other charts.

Tips

Make a template chart first. Format one chart with the title, fonts, legend, and colors you want, then duplicate it and change its data if that suits your workflow. Matching the dimensions is easier when the charts also use a consistent visual structure.
Leave room for the longest labels. A chart with longer category names or a more detailed legend can look crowded at the same size as a simpler chart. Choose dimensions based on the most demanding chart, not just the one with the shortest labels.
Use a consistent aspect ratio. If you want a dashboard to look orderly, use the same height-to-width proportions throughout. Changing width and height by very different amounts can make charts appear unusually tall or flat, even when Excel has applied the requested dimensions correctly.
Separate sizing from alignment. First make the chart objects the same size. Then position them and use alignment or distribution options to create even rows and columns. Equal size does not automatically give equal spacing.
Give charts useful names. In the Selection Pane, clear names such as Revenue by Month and Orders by Region are easier to select than a long list of generic object names. This is especially helpful when charts overlap or sit close together.
Check at the intended viewing scale. A dashboard that looks balanced at one zoom level may seem crowded at another. Review the worksheet at the zoom level people will normally use, and check a print preview if the charts are intended for a printed page.

Troubleshooting

The Format tab or Size boxes do not appear: Click the chart’s outer border again. If an individual title, legend, or data point is selected, Excel may show controls for that element instead. If the ribbon is collapsed or the Excel window is narrow, expand the ribbon or maximize the window. The contextual Format tab appears when a chart object is selected.

Only one chart changes size: The other charts may not have been included in the selection. Clear the selection, select the first chart border, and Ctrl-click each additional border on Windows, or Command-click on Mac. Confirm that every chart has outer selection handles before entering the dimensions. You can also select chart names together in the Selection Pane.

You cannot select or resize a chart: Check whether the worksheet is protected. On a protected sheet, object editing may be restricted even when cells can be edited. Ask the workbook owner to unprotect the sheet or change its protection settings to permit editing objects. If the chart is covered by another object, use the Selection Pane to select it by name.

The charts have equal dimensions but still look different: Compare the outside borders first. If those match, inspect the title, legend, axis labels, and plot area. Longer text or additional legend entries can change how the content is arranged inside a chart. Shorten labels, reposition or remove a legend where appropriate, or increase the size of all charts to give their contents more room.

The chart overlaps cells or another object after resizing: Resizing changes the object’s footprint but does not automatically rearrange the worksheet. Drag the chart by its border to a clear position, or adjust the row heights and column widths around it. If the charts must line up precisely, resize them first and then position them using the ribbon’s alignment options.

The units or numbers seem unexpected: Check the units shown beside the Height and Width fields and the values displayed after applying them. Excel may display inches or centimeters depending on regional and Office settings. Enter values in the units Excel shows, and do not assume that a number copied from another computer uses the same unit system.

Frequently Asked Questions

Can I make several charts the same size at once?
Yes. Select each embedded chart’s outer border on the same worksheet, then set Height and Width in the contextual Format tab. Use Ctrl-click on Windows or Command-click on Mac to add charts to the selection.

Do matching chart dimensions make the plots themselves the same size?
Not always. Excel matches the outside chart objects, while titles, legends, axis labels, and other content can take up different amounts of interior space. To make the plotted areas more alike, standardize the chart content and label lengths as well as the object dimensions.

Can I match charts on different worksheets in one selection?
No. Select and resize charts on one worksheet at a time, entering the same dimensions on each sheet. Keep a record of your chosen height and width so you can repeat them consistently.

Will these steps work in Excel for the web?
Excel for the web supports many chart-editing tasks, but ribbon layouts and multi-object selection options can differ from the Windows desktop app. If you cannot select multiple chart objects or find the Size controls, open the workbook in Excel for Microsoft 365 on Windows and use the contextual Format tab.

Can I type dimensions instead of dragging the chart?
Yes. Select the chart or charts, then enter numeric values in Height and Width on the contextual Format tab. This is the most reliable way to make multiple chart objects match exactly.

Does matching size also align the charts?
No. Size controls set the height and width, not the charts’ positions or the gaps between them. After sizing, move the charts into place and use alignment or distribution commands if you need an orderly layout.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.