How to Keep Excel Chart Size Consistent at Any Zoom Level in WPS Office
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.

- 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.
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.
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.
Click the chart in your worksheet so the chart border and selection handles appear.
Go to the Shape Format tab on the ribbon and locate the Size group at the right side.
Type the desired values in the Height and Width boxes, then press Enter.
Right-click the chart and choose Format Chart Area or Format Shape, then click Size & Properties.
Under Properties, select Don’t move or size with cells, then close the pane.

Verify Chart Size at Different Zoom Levels
Use this to confirm that the reported chart dimensions remain unchanged when you change the worksheet zoom.
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. Select the chart: Open your workbook in WPS Office Spreadsheets and click the chart you want to fix.
- 2. Open Shape Format: Go to the Shape Format tab on the WPS ribbon.
- 3. Set exact dimensions: Enter the desired height and width in the Size group, then press Enter.
- 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.

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.




