On one of my reports I have a Trigger. When a user clicks on a sheet(e.g. Sheet 1), it runs the macro "Zoom". I have that macro on all the sheets as a trigger. My users access the reports on a multitude of platforms such as laptops, computers, mobile phones and then so many different resolutions. My Zoom macro will automatically display the charts properly according to your personal resolution.