Excel2007 -- Precisely set plot area size?


G

Guest

I've searched books, Microsoft Help, and this board to find out how to
precisely resize the plot (not the chart) area and cannot find any
information. When I select the plot area, and change its size by entering
heigth & width values in the Size and Properties dialog box (Chart Tools
Format tab --> Size group) the chart area size also changes. I do not want
the chart area to change. How can I set values for the plot area and for the
chart area independently of each other?

Thanks to anyone who can help!
 
Ad

Advertisements

A

Andy Pope

Hi,

There is no, or has ever been, a UI which will allow you to specify the size
of the plotarea.

It maybe possible to provide this functionality via VBA.

Cheers
Andy
 
Ad

Advertisements

G

Guest


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

Top