I'm not sure if the observation is weird, or the actual chart sizing is. I think this is a bug, but I'm curious if others see similar behavior. This is an Office 2007 thing (at least, I haven't tested it in other versionsâ€¦) Here's the repro steps:
- Make a chart and select it
In the VBE, find out the width. I just did the following in the immediate window:
- It came back with 400. All good
Set the width to something (again in the immediate window):
Selection.width = 245
Now, check the width again:
- It comes back with 250
This strikes me as a little strange. I would have thought that the width would be the same as what I set it to. No matter the number given, it always seems to come back with a width that is 5 pixels larger than what I set it to.
The height and left properties do not seem to suffer this issue, only the width that I've encountered so farâ€¦
Anyone else get similar behavior?