remove white space without changing plot size

[Guest]

Now I know the white space can be removed by draging plot area but without
changing the size of plot I like to remove the white space. Is that
impossible ?

 

[Jon Peltier]

Not impossible, but it is hard to maintain the plot area size. You have
to first make the outer chart area rectangle as small as you need, then
make the plot area as large as you need. You'll probably have to cycle
through resizing of the two rectangles a few times.

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