If you don't need to keep it behaving as a chart, you can copy it as a picture,
paste it, and then actually crop it. If you copy it using the Picture option, you
can double click on the picture and ungroup the separate drawing objects, then
shrink or delete the rectangles that comprised the chart area. If you copy as a
bitmap, you can use the crop button on the picture toolbar to crop it.
If you want to keep your chart as a chart, it's not so easy. First you need to
format all the text elements in the chart, and uncheck the Autoscale box on the Font
tab. This prevents everything from changing in size. Then you have to shrink the
chart area (the larger outer box) and expand the plot area (the inner box) in a
coordinated effort.
If you use VBA, you can measure the plot area, shrink the chart area, and reapply
the plot area settings.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
