Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
plotarea restore automatic sizing
Hi,
the plotarea of a new chart is getting smaller, when a Title, legend or axis labels is added. When removing these items, the plotarea is automatically widen to the former size. But if the size of the plotarea was changed manually, the automatic sizing doesn't work any more. Is it possible to restore the automatic sizing of the plotarea? What VBA property contains the information, if the automatic sizing is working or not? Werner |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
plotarea restore automatic sizing
I think the only way to restore this behavior is to reapply the default
formatting of the chart. In 2003, select the chart, go to Chart menu Chart Type, and check the Default Formatting box under Options. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Werner News" wrote in message ... Hi, the plotarea of a new chart is getting smaller, when a Title, legend or axis labels is added. When removing these items, the plotarea is automatically widen to the former size. But if the size of the plotarea was changed manually, the automatic sizing doesn't work any more. Is it possible to restore the automatic sizing of the plotarea? What VBA property contains the information, if the automatic sizing is working or not? Werner |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
I think the only way to restore this behavior is to reapply thedefault
With ActiveChart
.PlotArea.Position = xlChartElementPositionAutomatic End With On Tuesday, February 05, 2008 3:27 AM Werner News wrote: Hi, the plotarea of a new chart is getting smaller, when a Title, legend or axis labels is added. When removing these items, the plotarea is automatically widen to the former size. But if the size of the plotarea was changed manually, the automatic sizing doesn't work any more. Is it possible to restore the automatic sizing of the plotarea? What VBA property contains the information, if the automatic sizing is working or not? Werner On Tuesday, February 05, 2008 7:22 AM Jon Peltier wrote: I think the only way to restore this behavior is to reapply the default formatting of the chart. In 2003, select the chart, go to Chart menu Chart Type, and check the Default Formatting box under Options. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Werner News" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PlotArea question | Charts and Charting in Excel | |||
Problem increasing .PlotArea.Height value | Charts and Charting in Excel | |||
Problem to modify the size of PlotArea | Charts and Charting in Excel | |||
Inexact? InsideTop and InsideLeft Method of PlotArea (Excel 97) | Charts and Charting in Excel | |||
Move/Resize PlotArea | Charts and Charting in Excel |