Thanks Jon,
I totally agree that the charts should have been created embedded on the
sheet to allow sizing and avoid font size distortion in the target
application. Unfortunately, there are literally hundreds of legacy workbooks
that can't be re-formatted (all linked in 2003 to PPT and now playing up).

Thanks for your tip with the margins. Will give that a go.
--
Cathy


"Cathy" wrote:

A chart created in 2007 and sitting in it's own sheet (not included on the
data worksheet) will not display entirely if pasted as link (neither into
Word nor PPT) Some of the chart seems to be "cut off" in the linked object.
This seems to be connected to how much of the "canvas" is visible in Excel.
Viewing the chart in Excel on a zoom so that it fills the whole screen seems
to remedy this. Is there some setting in Excel that would allow us to set the
worksheet chart to automatically size to window?

Or else: does anyone know a way of pasting a worksheet chart as a link but
detaching it from the view selected in the Excel Workbook?

Any help with this would be apprechiated as there are a large number of
Chart Libraries to be transferred into 2007. Anyone?...
--
Cathy