| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plot area of embedded charts unexplainably shrinks in Excel 2003 S | Charts and Charting in Excel | |||
| Chart Plot Area Drifts, Shrinks | Charts and Charting in Excel | |||
| Plot area shrinks and shifts | Charts and Charting in Excel | |||
| How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
| Resize chart area without resizing plot area | Charts and Charting in Excel | |||
Linear Mode
