Graph Size not adjusting with Chart Area and Plot Area

Do you really need to use a 3D chart type? 3D charts are first of all
notorious for their distortion of the data, but also they are not as easy to
work with manually or in VBA.

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


"Michael Malinsky" > wrote in message
ups.com...
>I am trying to create a chart using VBA. I attempted to create a
> starting point by creating the chart while the macro recorded was on so
> I could duplicate the result and adjust the code for user input, etc.
> The problem I am having is that when I run the unrevised code created
> from the macro recorded, the sizing of the Chart Area and Plot Area are
> properly duplicated (or close enough) from what was recorded in the
> macro, but the 3D Bar Graph contained within the Plot Area does not
> resize itself as it did when I performed the resizing manually during
> the macro recording. Any help would be greatly appreciated.
>
> TIA
> Mike.
>

Jon,

The 3D charts are not my choice...I'm just following orders. I am
attempting to use VBA to make it easier for the masses to insert a
chart into a spreadsheet. I actually solved the problem I described by
setting AutoScaling to True (although there are other issues to
resolve).

Thanks anyway,
Mike.

Jon Peltier wrote:
> Do you really need to use a 3D chart type? 3D charts are first of all
> notorious for their distortion of the data, but also they are not as easy to
> work with manually or in VBA.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "Michael Malinsky" > wrote in message
> ups.com...
> >I am trying to create a chart using VBA. I attempted to create a
> > starting point by creating the chart while the macro recorded was on so
> > I could duplicate the result and adjust the code for user input, etc.
> > The problem I am having is that when I run the unrevised code created
> > from the macro recorded, the sizing of the Chart Area and Plot Area are
> > properly duplicated (or close enough) from what was recorded in the
> > macro, but the 3D Bar Graph contained within the Plot Area does not
> > resize itself as it did when I performed the resizing manually during
> > the macro recording. Any help would be greatly appreciated.
> >
> > TIA
> > Mike.
> >