Microsoft Excel 
ITTraining@sgul.ac.uk Page 45 St. George’s Information Services 
RESIZING A CHART 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Try This Yourself: 
Same File Continue using the 
previous file with this 
exercise, or open the 
file E1317 
Charting_3.xlsx... 
 
Click on the chart to 
select it 
 
Point to the sizing 
handle on the left 
border of the chart until 
the mouse pointer 
changes to a double 
arrow 
 
Hold down the left 
mouse button and drag 
left until the chart 
appears as shown 
You can also resize a 
chart from the ribbon… 
 
Click on the CHART 
TOOLS: FORMAT tab  
 
Click on the up spinner 
arrow for Shape 
Height in the Size 
group until it shows 8.5 
cm 
 
Click on the up spinner 
arrow for Shape Width 
in the Size group until it 
shows 17 cm 
 
Click in cell A1 to 
deselect the chart 
 
3 
For Your Reference… 
To resize a chart: 
1. Select the chart, then click on and drag a 
sizing handle on the border of the chart, or 
 Click on the CHART TOOLS: FORMAT tab, 
then click on up/down spinner arrows for 
Shape Height and Shape Width in the Size 
group  
There are two main ways to resize a chart if you 
are not satisfied with its current size. A chart that 
has been selected can be resized by dragging 
one of the sizing handles around its border.  
These handles appear with dots in them. You can 
also resize a chart using commands in the Size 
group on the CHART TOOLS: FORMAT tab that 
appears when the chart is selected. 
4 
Handy to Know… 
 If you wish to change the size of a chart 
quickly and easily, clicking on and dragging 
the resize handles is the best option whereas 
if you want to resize a chart to a specific size 
it is best to resize the chart using the tools in 
the Size group on the CHART TOOLS: 
FORMAT tab.