Consider this scenario:
1. When you try to resize charts on a chart sheet, Excel displays the resize handle, but it won't let you resize the chart.
2. After upgrading a file created in Excel 2007 if the chart is positioned to be small on the chart sheet, it will snap to maximum size on the chart sheet.
-Resize the plot area and position other elements to match.
-Embed the chart in the worksheet instead of a chart sheet. To do this, follow these steps:
- Highlight the chart.
- On the Chart Tools ribbon choose Design
- Click on Move Chart
- Choose where you want the chart to be placed: Object in: Choose the worksheet tab you want to place it.
- Click OK.