Hi,

I have a worksheet with about 8 charts on it. On all but 1 chart, when I
delete the Chart Title, the plot area expands. Can anyone tell me why this
happens? I'm no chart expert and I can't seem to find any obvious setting
that would control that behavior.
--
TIA
Chuck M.

If you have not manually adjusted the plot area size, Excel considers it the
default size. This default size changes based on whether there are axis
titles, a chart title, and a legend. Adding or removing any of these
features causes the Excel to change the plot area,

To prevent this behavior, change the size of the plot area manually.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Chuck M" <(E-Mail Removed)> wrote in message
news:75AFF9C2-7A52-45BE-AE6B-(E-Mail Removed)...
> Hi,
>
> I have a worksheet with about 8 charts on it. On all but 1 chart, when I
> delete the Chart Title, the plot area expands. Can anyone tell me why this
> happens? I'm no chart expert and I can't seem to find any obvious setting
> that would control that behavior.
> --
> TIA
> Chuck M.

Thanks Jon! My user actually does want the plot size to change. I know that
the user has changed the plot size manually in the past. I can now explain
why this particular chart behaves the way it does.

BTW - I have visited your website many times and have found it a great
resource!

Thanks again.
Chuck M.


"Jon Peltier" wrote:

> If you have not manually adjusted the plot area size, Excel considers it the
> default size. This default size changes based on whether there are axis
> titles, a chart title, and a legend. Adding or removing any of these
> features causes the Excel to change the plot area,
>
> To prevent this behavior, change the size of the plot area manually.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "Chuck M" <(E-Mail Removed)> wrote in message
> news:75AFF9C2-7A52-45BE-AE6B-(E-Mail Removed)...
> > Hi,
> >
> > I have a worksheet with about 8 charts on it. On all but 1 chart, when I
> > delete the Chart Title, the plot area expands. Can anyone tell me why this
> > happens? I'm no chart expert and I can't seem to find any obvious setting
> > that would control that behavior.
> > --
> > TIA
> > Chuck M.
>
>
>