'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Resize a Chart in Excel, Word, or PowerPoint
Question details
The user wants to adjust the dimensions of a chart in Microsoft Excel, Word, or PowerPoint to better fit their document layout.
- Product
- Excel, Word, PowerPoint
- Device & OS
- not provided
- Scenario
- Adjusting document layout and formatting charts for clearer presentation and visualization.
- Observed behavior
- The user needs to change the width and height of an existing chart either proportionally using their mouse or by entering exact measurement values.
Ensure you have inserted a chart into your document and click on it once to reveal its border and sizing handles before attempting to resize.
Resize a Chart Quickly Using Drag Handles
Use this method for quick, visual adjustments to your chart's size without needing exact measurements.
The quickest way to adjust a chart's dimensions is by using the sizing handles on its border. This allows you to visually scale the chart to fit your text or slide layout.
Click anywhere on the chart to activate it. You will see a border appear with circular or square sizing handles on the corners and sides.
Click and drag one of the corner sizing handles diagonally. This changes the height and width simultaneously, keeping the chart's aspect ratio intact.
To change only the width or only the height, click and drag a sizing handle located on the top, bottom, left, or right edges of the chart border.
If the resized chart needs to be moved, click a blank area inside the chart (avoiding specific elements like the title) and drag it to a new location.
Resize a Chart to Precise Dimensions
Use the Format tab when you need your chart to be an exact size in inches or centimeters for professional printing or strict layout requirements.
How to Resize Charts Effortlessly in WPS Office
WPS Office provides a highly intuitive interface to insert, format, and resize charts across its Writer, Spreadsheet, and Presentation tools. You can easily drag to resize or enter exact dimensions, just as you would in Microsoft Office.
- 1. Insert or Select a Chart: Open your document in WPS Office and click on the existing chart to reveal the border and sizing handles.
- 2. Drag to Resize: Click and drag any corner handle to scale the chart proportionally, or use the side handles for specific width and height stretching.
- 3. Set Precise Sizes: Go to the 'Chart Tools' tab on the top ribbon and input exact measurements in the Size section for pixel-perfect alignment.
Frequently Asked Questions
How do I resize only the plot area of the chart without changing the whole chart size?
Click once on the chart to select it, then click specifically on the plot area (the inner box where the data is actually drawn). Sizing handles will appear around just the plot area, allowing you to drag them to adjust its size within the main chart canvas.
Why does my Excel chart change size when I adjust the worksheet cells?
By default, charts in Excel are set to move and size with cells. To stop this behavior, right-click the chart, select 'Format Chart Area', navigate to 'Properties' under the Size & Properties icon, and choose 'Don't move or size with cells'.
Can I resize multiple charts to be the exact same size at once?
Yes. Hold the 'Ctrl' key (or 'Cmd' on Mac) and click on multiple charts to select them all at the same time. Then, go to the Chart Format tab and enter your desired height and width in the Size group. All selected charts will instantly update to the new dimensions.
How can I ensure my chart text doesn't look too small after making the chart smaller?
When you drastically reduce a chart's size, the font sizes might not automatically scale down perfectly, or they might become unreadable. You can fix this by clicking the chart, going to the 'Home' tab, and manually adjusting the font size to ensure it remains legible.
