Importing Charts from Excel
- 02:41
Learn to import excel charts to your presentations
Downloads
No associated resources to download.
Transcript
If you want to import a chart from an Excel file, first thing to do is copy the chart. Okay, so go to your Excel file, use control C to copy the chart, go back to your PowerPoint and then use the paste, special shortcut to paste. So if you use control ALT V that's the best shortcut to use for this and it gives you lots of paste options in there. Now the option we choose depends on whether or not we want the chart to continue to update as we change the values in the spreadsheet or if we just want to paste a really high quality picture. Okay, so I'm gonna show you both methods here. So let's, the first thing we're going to do is paste it as a picture, as an enhanced meta file, okay? And if you hit okay, this will give you a really good, clear and crisp picture of your chart. And it also means, because it's a picture, you can easily resize it. And as you do so, the font size will update as well. Okay, so it's a very, very, very simple and effective way of pasting a chart. But remember, the data in the chart is static. Okay, I'm gonna get rid of that background there. So, okay, so this has got static data. If I now do the same thing, so I've already, actually, I've already copied it so I'm gonna paste special again, control alt V. This time I'm going to select Microsoft Office graphic object and hit okay. So it looks slightly different. Okay, looks very, very slightly different. It's a few issues with the colors. It's about the same size but now have I try to resize the chart. Okay, it doesn't do it exactly as it did before. The font size stays exactly the same. Okay, if I make it bigger, the font size stays the same as well, right? What else changes? Well, what it means is I can go back to the underlying spreadsheet, and if I change some of those values, let's say I change the revenue for company A to a thousand and hit enter, then, obviously the chart in the Excel spreadsheet will update. If we go back to our PowerPoint slide, the chart on the left hasn't changed at all but the chart on the right has done. Okay, so depending on what you're trying to achieve should determine whether or not you use just a picture like we've done on the left hand side or we use one of these Microsoft Office graphic objects as we have done on the right hand side. Obviously this is going to use up more memory and give you a bigger file but that's a small price to pay. It means you don't have to keep copying and pasting your charts from Excel into PowerPoint.