Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
When it comes creating charts in Office 2011, Excel does the best job by far. Yes, if you know where to look, you can find tools to create charts in Word or PowerPoint, but Excel's tools are by far the most sophisticated and powerful. In this movie, I'll show you how to include an Excel chart in your other Office documents. So here in Excel, I have a chart, and I'll just click it. So once the chart is selected, I can press Command+C to copy it, and now, let's say that I want to paste it into a Word document.
To do that, I just press Command+Tab to move over to my Word file, click on an empty line, and press Command+V to paste. And when I do, the chart gets pasted in. But what's neat about pasting an Excel chart into another Office document is that Office creates a live link between the original chart and its data and this chart. So let me Command+Tab to switch back to Excel. I'll change the values so that the change in the chart is very obvious.
So I will change the value for 2008 for Lemon, to 30,000. So in this notional universe, we just sold 30,000 bottles of lemon-infused olive oil in the year 2008, and you'll see that that change is reflected here in the chart. When I press Command+Tab to go back to Word, you see that the change has been reflected immediately. If I go back to Excel and undo the change by pressing Command+Z, this chart changes, and Command+Tab to go back; that chart changes as well.
So it's called a live data link. But now, let's say that when I paste the chart from Excel into Word, I don't necessarily want to maintain a live link. Well, that's when I can use the options that are available by clicking the Paste Options button that appears here. When I click it, I get several different options. I can paste it as a picture, which just leaves it as an image, and it's not connected to the original chart, or I can click Excel Chart (entire workbook), and what that does is it creates a copy of the entire workbook and embeds it in this Word document.
So in other words, there's no longer a live link between this chart and the original file, because a copy of that file has been placed inside this Word document. So any changes you make to the original will have no effect on this chart. So just to show you what it looks like, I will click Paste as Picture, and when you do, you get an image of the chart. And if I take it down on the zoom level to 100%, you see what the image of the chart will look like when you print it. Including Excel charts in other Office documents can be as simple as copying and pasting the chart, or an image of the chart, into your document or a presentation.
Or, if you prefer, you can embed a copy of the entire workbook if you can't take a copy of the workbook with you.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 86890 Viewers
80 Video lessons · 136104 Viewers
59 Video lessons · 54803 Viewers
52 Video lessons · 68703 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.