• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Disable Automatic Re-Sizing of Excel 2007 Charts

E

Erich_Weber

New Member
Hello!


I created an Excel 2003 spreadsheet with six individual charts. My company recently 'upgraded' to Excel 2007, and now the charts are automatically moved and made smaller whenever I copy a sheet or save the file. How do I disable this?
 
Erich


Firstly, Welcome to the Chandoo.org Forums


Select the chart

Right Click on the edge and select Format Chart Area

Goto Properties, select Don't Move & Size with Cells

Repeat for each chart

Save the file


You can select all the charts using Shift whilst selecting them

Right Click on the edge and select Format Chart Area

Goto Properties, select Don't Move & Size with Cells

Save the file
 
You must log in or register to reply here.
Back
Top