 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / July 2007How to "crop" charts created in Excel and moved to Word
Does anyone know if I can "crop" an Excel chart which has been imported into Word. This is possible for pictures but I can't seem to do it for a chart. I'm using Office 2007 If you paste the chart as a picture, you can crop the picture of the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Does anyone know if I can "crop" an Excel chart which has been imported > into > Word. This is possible for pictures but I can't seem to do it for a chart. > I'm using Office 2007 Thanks Jon. This does work but unfortunately the quality of the picture is poor compared to the original chart. This is not good for publication purposes. However I do appeciate your taking the time to respond to my question. Jim. > If you paste the chart as a picture, you can crop the picture of the chart. > [quoted text clipped - 9 lines] > > Word. This is possible for pictures but I can't seem to do it for a chart. > > I'm using Office 2007 If you have pasted the chart as a bitmap, and resizing you do is likely to degrade image appearance. It would be better to size everything as much as possible in Excel; stretch the plot area and move other chart elements, so that cropping and resizing in Word is unnecessary. Then paste as a picture (metafile). Hmmm, the above was for Excel 2003 and prior, and I just noticed you mentioned 2007. Metafiles of charts look pretty poor in 2007, and bitmaps end up being a marginally better option. You should still adjust the chart as much as possible in Excel to minimize manipulation within Word. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Thanks Jon. This does work but unfortunately the quality of the picture is > poor compared to the original chart. This is not good for publication [quoted text clipped - 17 lines] >> > chart. >> > I'm using Office 2007 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.