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
