Graph Size not adjusting with Chart Area and Plot Area

[Michael Malinsky]

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 Peltier]

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

 

[Michael Malinsky]

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.