Hello. I hope someone can help me with this one.
I have an object floating over a chart. The object consists of several connected rectangles, each containing textboxes. The individual portions making up the object are grouped into one object. Basically it is a legned for the x-axis.
The object is used to describe different sections of the xy-scatter chart. The rectangles are connected at certain specific x-axis values.
My problem is that when I save the worksheet and re-open it, excel has automatically resized the object for some reason (thus the sides of the rectangles are no longer at set up at the correct x-axis values). The height of the object is not changed, but the width is changed from 14.57 to 14.32 (within format...object...size).
The object is locked, and the worksheet is protected. Even the aspect ratio of the object is locked, so one dimension should not be able to change without the other one changing. I'm stumped.
It only happens on saving. It looks just the way I want it after I enter the data that is plotted on the chart, but not after it is opened after saving (it needs to be opened by a couple of different people in the course of completing the worksheet, so it needs to be saved and re-opened).
Is this something I am doing to cause this? Could it be a known issue within excel (XL97)?
ANY help is greatly appreciated!
Thanks,
Corey D.
I have an object floating over a chart. The object consists of several connected rectangles, each containing textboxes. The individual portions making up the object are grouped into one object. Basically it is a legned for the x-axis.
The object is used to describe different sections of the xy-scatter chart. The rectangles are connected at certain specific x-axis values.
My problem is that when I save the worksheet and re-open it, excel has automatically resized the object for some reason (thus the sides of the rectangles are no longer at set up at the correct x-axis values). The height of the object is not changed, but the width is changed from 14.57 to 14.32 (within format...object...size).
The object is locked, and the worksheet is protected. Even the aspect ratio of the object is locked, so one dimension should not be able to change without the other one changing. I'm stumped.
It only happens on saving. It looks just the way I want it after I enter the data that is plotted on the chart, but not after it is opened after saving (it needs to be opened by a couple of different people in the course of completing the worksheet, so it needs to be saved and re-opened).
Is this something I am doing to cause this? Could it be a known issue within excel (XL97)?
ANY help is greatly appreciated!
Thanks,
Corey D.