Fix Chart Size

[GDunn]

I have pages of numerical results and Excel charts, the data comes from a table with ODBC links.
When I Refresh All data links and return to my results sheets some of the charts have lost their formatting and have extended out of my print area.
This file will be available to a number of users and refreshed periodically, so I need to fix the chart sizes in order to make available to the general population.
Any ideas? Have tried all of the standard settings within Chart Tools, including Snapping.

 

[tusharm]

If any of the charts is a PivotChart, Excel will reformat certain aspects of it on every refresh. Your only choices are to either not use a PC (instead use a regular chart) or write a macro to redo the formatting each refresh or not format/resize the charts in the first place.