Plot Area shrinks

[CLR]

Hi All......
I have a complex Workbook that uses a Report Sheet to bring in data from a
internal Database Sheet to create a "report" and 3 small charts. The
Workbook uses many complex formulas and macros in it's operation.
Occasionally, (not intentionally repeatable), two of the charts will have
their Plot Areas shrink in height to about one quarter their normal
height.....it's easy to drag them back to size, but it shouldn't be doing
that.......any idea why, and how to prevent it from happening?

TIA
Vaya con Dios,
Chuck, CABGx3

 

[HelpExcel.com]

Chuck,

Uncertain why it is happening, but you could use VBA to FORCE the desired
size.

 

[CLR]

Thanks Eddie.......good thought, I'll look in to that.

Vaya con Dios,
Chuck, CABGx3