I have 2 forms that have Excel charts in OLE Bound Controls. In general things work the way I expect them to. One of my bar charts, when I have more than 4 bars showing, has the right side of the chart cropped. When I double-click on the control, I go into Excel (how do I stop this behavior?). When I escape out of Excel, the chart shows uncropped. I tried doing a Refresh on the control from Init. That did not help.

Any thoughts?


In the meantime I have discovered DoVerb for OLE bound controls. The -1 verb opens the chart in Excel. How do I do the equivalent of pressing Escape (yes I get some screen flashing, but my chart image is no longer cropped)?


Tim