Move Or Resize Chart. 2 In Excel 2007 click Properties tab and select Dont move or size with cells option. When you change the size of cells on the worksheet the size of the chart adjusts accordingly.
To move a chart manually hover your mouse over the chart area until you see a 4-headed arrow. When you change the size of cells on the worksheet the size of the chart adjusts accordingly. Click the chart.
To move a chart drag it to the location that you want.
Select the chart you want to resize and make sure the circular move handles appear on the border around the chart. To investigate the Chart too small issue I suggest you try to reset the default printer to see the outcome. How to Move and Resize elements Select the chart element you want to move or resize. When you change the size of cells on the worksheet the size of the chart adjusts accordingly.