Chart moves when file is opened
I have an Excel file with pie charts in many worksheets. Many times when I open the file, the position of these charts is changed. They charts just seem to drift.
Is there a way I can lock the location of these charts to a certain cell?
excel opens to last position saved
so you'll need vba on save to make sure charts are in the right place
in the work book module something like
where d8 is upper left cell of chartCode:Sheets("Sheet2").Select Range("D8").Select
Last edited by martindwilson; 10-29-2009 at 09:28 PM.
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks