Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pasting chart worksheet as link 2007
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pasting chart worksheet as link 2007
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Cathy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pasting chart worksheet as link 2007
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
How do I keep chart/data link when copying worksheet | Charts and Charting in Excel | |||
How To: Link worksheet data to pre-existing chart tables | Excel Discussion (Misc queries) | |||
How To: Link worksheet data to pre-existing chart tables | Excel Worksheet Functions | |||
How To: Link worksheet data to pre-existing chart tables | Charts and Charting in Excel |