Crop excel charts
in [Charts]
|
Prev: Horizontal Error Bars in Excel 2007
Next: How do I add category labels in a chart but keep series separate?
From: adam on 7 Dec 2009 08:57 Simple solution is to paste the chart into a blank Word document formated to be 2003 compatable, you can then crop it, and copy and paste it where ever you want. You need to format the document first otherwise when you reformat it makes a mess of the chart. Dont use the paste as picture option others might suggest it reduces the quality. Ji wrote: How to "crop" charts created in Excel and moved to Word 26-Jul-07 Does anyone know if I can "crop" an Excel chart which has been imported into Word. This is possible for pictures but I cannot seem to do it for a chart. I am using Office 2007 Previous Posts In This Thread: On Thursday, July 26, 2007 8:26 AM Ji wrote: How 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 cannot seem to do it for a chart. I am using Office 2007 On Thursday, July 26, 2007 9:19 AM Jon Peltier wrote: If you paste the chart as a picture, you can crop the picture of the chart. 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 _______ "Jim" <Jim(a)discussions.microsoft.com> wrote in message news:663604AC-82C4-4257-940F-E3A73A56CC83(a)microsoft.com... On Thursday, July 26, 2007 9:36 AM Ji wrote: Thanks Jon. 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. "Jon Peltier" wrote: On Thursday, July 26, 2007 10:13 AM Jon Peltier wrote: If you have pasted the chart as a bitmap, and resizing you do is likely to 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 _______ "Jim" <Jim(a)discussions.microsoft.com> wrote in message news:F6F5843A-9AC2-48B2-BCE1-A3BD242EF76F(a)microsoft.com... Submitted via EggHeadCafe - Software Developer Portal of Choice AJAX enabled web page design and beginner?s concept http://www.eggheadcafe.com/tutorials/aspnet/c5dfe5fc-b2bd-4086-97e6-c132b45b71e4/ajax-enabled-web-page-des.aspx |