Graph Size not adjusting with Chart Area and Plot Area

  • Thread starter Michael Malinsky
  • Start date

M

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.
 
Ad

Advertisements

J

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
 
Ad

Advertisements

M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart sizing 1
chart area & plot area 1
Making charts 1
Chart size 1
Setting chart size in macro 1
Seemingly random plot area drift? 2
Format Selected Chart 3
controlling plot area 1

Top