Pasting chart worksheet as link 2007

[Cathy]

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

 

[Jon Peltier]

The SizeToWindow setting was removed from Excel 2007 (I don't understand
why).

I generally work with embedded charts, partly because they seem more
reliable for my purposes when inserting them into other applications. If you
can't use embedded charts, could you perhaps enlarge the margins of the
chart sheet (page setup/page layout) to make the chart smaller? If I use
chart sheets, I will shrink the chart to fit the required size in Word or
PowerPoint by fiddling with thee margins. Using either embedded charts or
chart sheets, it is important to size the chart appropriately in Excel so it
needs no resizing in the target application

- Jon

 

[Cathy]

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.