Plot Area shrinks
 

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

Plot Area shrinks
 

Chuck,

Uncertain why it is happening, but you could use VBA to FORCE the desired
size.
--
Regards,
Eddie
http://www.HelpExcel.com


"CLR" wrote:

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

Plot Area shrinks
 

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

Vaya con Dios,
Chuck, CABGx3



"HelpExcel.com" wrote:

Chuck,

Uncertain why it is happening, but you could use VBA to FORCE the desired
size.
--
Regards,
Eddie
http://www.HelpExcel.com


"CLR" wrote:

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