Cannot Resize the Chart Area of a chart located on a Chartsheet

Symptoms
Starting from Excel 2010,  you cannot adjust the size of the chart area when the chart is located on a chart sheet. Excel 2007 would allow you to resize the chart area.

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. 
More information
This behavior was changed in Excel 2010 and later versions, which is the intended design. 


Workaround
Alternatives to resizing the chart area on the chart sheet include:

-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: 
  1. Highlight the chart.
  2. On the Chart Tools ribbon choose Design
  3. Click on Move Chart
  4. Choose where you want the chart to be placed: Object in: Choose the worksheet tab you want to place it.
  5. Click OK.

chart sheet resize worksheet XL2010 XL2013 adjust
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2850644 - Last Review: 09/23/2015 08:57:00 - Revision: 3.0

Microsoft Excel 2010, Microsoft Excel 2013, Excel 2016

  • KB2850644
Feedback