Chart & Visualization Issues

How to Resize an Excel Chart Without Distorting It

Adam Davis Oct 22, 2026 869 views

Question details

The user wants to resize a chart in Excel while maintaining its visual proportions to avoid stretching or distorting the data elements.

How to Resize an Excel Chart Without Distorting It

Product: Excel
Device & OS: not provided
Scenario: Adjusting chart dimensions for better spreadsheet layout or presentation without skewing the graphical representation of the data.
Observed behavior: The user needs to achieve proportional resizing, configure exact width and height dimensions, and control how the chart interacts with changing worksheet cells.

Before you start

Ensure you click near the outer edge of the chart to select the entire 'Chart Area' rather than the inner 'Plot Area', which would only resize the data graph inside the box.

Solution 1Recommended

Resize Proportionally Using Corner Sizing Handles

The quickest way to resize a chart without losing its original aspect ratio is by using keyboard modifiers while dragging the corner handles.

Dragging the side handles will stretch the chart horizontally or vertically, causing distortion. Always use the corner handles in combination with the Shift key to lock the proportions.

Select the chart

Click anywhere on the blank outer area of your chart to make it active. You will see eight circular sizing handles appear around the border.

Hover over a corner

Move your mouse cursor over one of the four corner handles until the cursor turns into a double-sided diagonal arrow.

Hold the Shift key

Press and hold down the 'Shift' key on your keyboard. This tells Excel to lock the aspect ratio.

Drag to resize

While holding 'Shift', click and drag the corner handle inward to make the chart smaller, or outward to enlarge it. Release the mouse button before releasing the Shift key.

Resize Proportionally Using Corner Sizing Handles

Tip: If you hold down the 'Alt' key while dragging, the chart edges will snap to the spreadsheet gridlines, making it easier to align with specific cells.

Solution 2

Set Precise Dimensions Using Chart Format Options

If you need specific height and width measurements for your chart, use the Format options to enter exact numbers while locking the aspect ratio.

Solution 3

Control Chart Resizing Behavior with Worksheet Cells

Prevent unexpected distortion when editing your spreadsheet by locking the chart's size relative to the underlying cells.

Effortless Chart Management

Easily Resize and Format Charts in WPS Spreadsheet

WPS Spreadsheet offers intuitive chart manipulation tools, allowing you to resize, format, and lock chart proportions effortlessly. Enjoy a smooth data visualization experience that is fully compatible with Microsoft Excel.

1. Select the chart: Open your spreadsheet in WPS Office and click on the outer border of the chart.
2. Resize with Shift: Hold the Shift key and drag any corner sizing handle to scale the chart up or down proportionally.
3. Set precise sizes: To be exact, right-click the chart, choose 'Format Object', and navigate to the Size tab.
4. Lock proportions: Tick the 'Lock aspect ratio' option and enter your desired height or width to perfectly size the chart without distortion.

Fully compatible with Microsoft Excel (.xlsx) formatsIntuitive drag-and-drop chart resizing while maintaining aspect ratioPrecise chart dimension settings for professional reports and presentationsFree, lightweight, and fast-loading office suite alternative

microsoft office alternative - wps office

Frequently Asked Questions

Why does my chart get distorted when I resize columns in my spreadsheet?

By default, charts are set to 'Move and size with cells'. If you adjust the width of columns or the height of rows located underneath the chart, the chart stretches along with them. To fix this, right-click the chart, go to Format Chart Area > Size & Properties > Properties, and select 'Move but don't size with cells'.

Can I resize multiple charts at the same time to the exact same size?

Yes. Hold the 'Ctrl' key and click on the outer edge of each chart you want to resize to select them all. Once all are highlighted, go to the Format tab on the ribbon and enter your desired Height and Width in the Size group. All selected charts will instantly snap to these identical dimensions.

Why does only the inside of my chart resize instead of the entire chart box?

You likely selected the 'Plot Area' (the inner box containing the actual data series bars or lines) instead of the overarching 'Chart Area'. Ensure you click near the outer blank border of the chart so the resizing handles appear on the very edge before you attempt to resize it.

Excel & Data Problems