Unless you have good reasons to choose some other settings, the best way to copy a chart into Excel is to: • choose Edit > Paste Special and choose to paste as Picture (Enhanced Metafile) • double-click the chart and on the Layout tab, choose In line with text. This page explains the ins and outs of copying an Excel chart into Word. There are four things to think about: • Do you want to link your chart to the source workbook? • What format is best for your chart? • How do you want text to flow around your chart? • How do you control the size of text in the chart? Do you want to link your chart to the source file? You can paste a chart into Word and link it to its source file. If you do that, whenever you make a change in the source Excel file, Word can update the chart in your document to reflect the changes in the source Excel file. To link your chart to its source you need the Paste Special dialog. To see it: • in Word 2003 and earlier versions, do Edit > Paste Special. • in Word 2007 and later versions, on the Home tab, click the little arrow below the Paste button (it's called a split button; you need the bottom half), and choose Paste Special. Within the Paste Special dialog, select the Paste Link option (Figure 2). Figure 2: To link the chart in your Word document to its source Excel file, choose the Paste link option. If you link your chart, when you double-click the chart in Word, Excel opens the original file, where you can edit it. When you return to Word, your Word document will reflect your changes. What format is best for pasting a chart? Your options for pasting depend on what version of Word you have, and whether you are linking the chart in Word to the source Excel data file. Here are the main options: Paste as a picture You can paste the chart as a picture. If you do this, the file size is small and you can treat it like a picture: re-size, rotate, convert to a drawing object so you can edit the text, and re-colour elements of the chart. For most tasks, pasting as a picture is my preferred method. To paste your Excel chart as a picture, follow one of these methods: • In Excel, click the chart. In Word, choose Edit > Paste Special and choose to paste as a Picture (Enhanced Metafile). • In Excel, click the chart once and be sure it shows 8 small black square markers on the edge. If you need tech support at any given point in time, just dial iYogi™ toll-free number 1-877-524-9644 from the U.S. Or Canada, or 0-800-635-0761 from the U.K. IYogi warrants that the content in this video is provided on an “as is” basis with no express or implied warranties whatsoever. Here is how to make a free flow chart with flow chart creator: Step 1 Knowing what each basic symbol means should be considered and deciding on what type of Step 2 Collecting possible answers and/or ideas can extend or expand the chart in different ways, some are vertical and some are horizontal, so. Free microsoft excel download for mac. Do Edit > Copy, or just ctrl-c. In Word, do Edit > Paste, or just ctrl-v. Paste as an Excel chart Alternatively, you can paste the chart as an Excel chart. ![]() This imports the entire workbook into your Word document, so you can end up with a very large file. And, you risk disclosing the source data—and anything else that is in the Excel file—to the reader of your Word document. To paste your Excel chart as an Excel chart object, follow one of these methods: • In Excel, click the chart. In Word, choose Edit > Paste Special and choose to paste as an Microsoft Office Excel Chart Object. • In Excel, hold down the Ctrl key and click the chart. Make sure it shows 8 hollow round markers on the edge. Do Edit > Copy, or just ctrl-c. In Word, do Edit > Paste, or just ctrl-v. If your chart is in Word as an Excel chart, you can double-click the chart to edit the chart or anything else in the Excel file, including the source data for the chart. When you're finished, click outside the chart, in the main body of the Word document. How do you want the text to flow around the chart? Should your chart be in-line or floating? Your chart can sit in Word either in-line or floating. This controls the placement of your chart and how text flows around the chart. If you want text over the chart, behind the chart, or to wrap around the chart, then your chart needs to float.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |