I have a dynamic xy chart that has a shrinking plot area problem. Each time I save the file and reopen it (whether I added data to the plot or not), the y-axis moves a tiny bit, shrinking the plot area. I have XL07, but the file is saved as 97-03 for compatibility. I'm not using any macros. It's a simple report with two embedded charts. One uses the secondary y-axis, and this chart shrinks in from both sides. The other chart only shrinks from the primary y-axis. Under normal conditions, I have all worksheets and the workbook "Protected" with a password to prevent users from reformatting anything, but it didn't make any difference to the problem. Typically, once per hour the file will be opened, a line of data is appended to the "Data" worksheet, the file is saved and closed. I can reopen the file, make no changes to it, and if I save it on closing then the next time I open it, the axes will have moved in the plot area. I also do not understand why it asks me if I want to save on exiting if I've made no changes to the file. Thanks for any help.
Bookmarks