stop charts resizing plot

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Stop charts from resizing plot area, legend, etc. | Excel forum

Stop charts from resizing plot area, legend, etc. | Excel forum

resolvedResolved · High Priority · Version 2003

Li-kim has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Stop charts from resizing plot area, legend, etc.

I am plotting several charts, plus am lining up all of their axes, etc. to be along 1 line vertically and 1 line horizontally, using the gridlines of the cells (no colour in plot area = transparent chart).

How do I stop my charts from resizing the plot area and legend? I have "fixed" my charts to move and resize with the cells, plus removed font autoscaling -- these are working fine so that the main larger area of the graphs are all "fixed".

However, the box containing the plots keep resizing, moving from the positions I adjusted them to previously. This occurs every time I reopen my file (same computer, different computer, makes no difference), resave, view at different scaling/magnification, etc.


RE: Stop charts from resizing plot area, legend, etc.

Hello Li-kim

Thank you for your question.

I have had a look into this on the internet, apparently it is a common problem/complaint going back a while, I found posts from Excel 97 users in various forums about the same problem.

Unfortunately there appears to be no simple solution to this, despite the fact that it has been a known problem for a while, and therefore there isn't really anything that we can suggest to help in this case.

Kind regards
Amanda

Mon 15 Jun 2009: Automatically marked as resolved.


 

Excel articles

Please browse our web site to find out more about
microsoft excel training courses and other training courses.

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.09 secs.