Chart & Visualization Issues

How to Keep Excel Chart Size Consistent at Any Zoom Level in WPS Office

Olivia MillerOlivia Miller Nov 13, 2026 869 views

Question details

The user needs to keep a chart’s dimensions consistent when the worksheet zoom level changes, instead of relying on how the chart appears visually.

How to Keep Excel Chart Size Consistent at Any Zoom Level in WPS Office
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
A user is working with a chart in a spreadsheet and wants the chart height and width to remain fixed while changing worksheet zoom.
Observed behavior
The chart may seem to change size at different zoom percentages because of display rounding, shape formatting, or measuring the chart visually rather than checking its actual Size properties.
Before you start

Open the spreadsheet that contains the chart and make sure the chart is selected. Have the exact height and width values you want to apply ready before you adjust the chart properties.

Solution 1Recommended

Set Exact Chart Height and Width from Shape Format

Use this when the chart appears to change size with zoom and you need to apply precise dimensions that remain constant.

WPS Office Spreadsheets stores chart dimensions in points. Zoom changes only magnify the display; they do not change the stored height and width, but screen rounding can make the size look different.

1
Select the chart

Click the chart in your worksheet so the chart border and selection handles appear.

2
Open Shape Format > Size

Go to the Shape Format tab on the ribbon and locate the Size group at the right side.

3
Enter exact height and width

Type the desired values in the Height and Width boxes, then press Enter.

4
Open Size & Properties

Right-click the chart and choose Format Chart Area or Format Shape, then click Size & Properties.

5
Prevent cell-based resizing

Under Properties, select Don’t move or size with cells, then close the pane.

Set Exact Chart Height and Width from Shape Format
Chart size now remains consistent: The chart keeps its set height and width. Zoom changes only affect screen magnification, not the stored dimensions.
WPS Spreadsheets

Keep Chart Dimensions Fixed in WPS Office Spreadsheets

WPS Office Spreadsheets lets you set an exact chart height and width and stop the chart from moving or resizing with cells, so the size remains consistent at every zoom level.

  1. 1. Select the chart: Open your workbook in WPS Office Spreadsheets and click the chart you want to fix.
  2. 2. Open Shape Format: Go to the Shape Format tab on the WPS ribbon.
  3. 3. Set exact dimensions: Enter the desired height and width in the Size group, then press Enter.
  4. 4. Lock position and size: Right-click the chart, choose Format Chart Area > Size & Properties > Properties, and select Don’t move or size with cells.
Exact height and width controls keep chart size stableDon’t move or size with cells prevents accidental resizingFull compatibility with Excel .xlsx chart filesFamiliar ribbon layout makes the transition from Microsoft Excel easyFree, lightweight Office suite for daily spreadsheet work
microsoft office alternative - wps office

Frequently Asked Questions

Why does my chart look bigger or smaller when I change the worksheet zoom?

The stored height and width do not change with zoom. The apparent size change is caused by display magnification and rounding, so check the actual values under Shape Format > Size.

How do I stop a chart from resizing when I change row or column sizes?

Select the chart, open Format Chart Area > Size & Properties > Properties, and choose Don’t move or size with cells.

Can I check the actual chart size without measuring it on screen?

Yes. Select the chart and read the Height and Width boxes under Shape Format > Size, or use a VBA macro to print the chart dimensions at different zoom levels.

Does this method work for Excel charts opened in WPS Office?

Yes. WPS Office Spreadsheets opens Excel .xlsx workbooks and preserves chart objects, so you can use the same Shape Format controls to fix chart size.