Bob from Dallas writes in with a question. Bob has created a chart in Excel and needs to copy the chart to a slide in PowerPoint. For those of you who never leave Excel, PowerPoint is a tiny little Add-In that Microsoft created to help Excellers when they need to make presentations. Although there are 7 ways to accomplish this task, Episode 492 takes a look at the best way to get your Excel charts on to a slide in PowerPoint.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
Today we have a question sent in by Bob from Dallas.
Bob is interested in taking a chart from excel and pasting it over to powerpoint.
Now I know that we use excel for everything but occasionally sometimes we have to go outside of excel and microsoft has provided some great little add-in tools that work well with excel and today we're going to learn how to take a chart from excel over to that another little add-in called powerpoint.
So I have some data here in excel.
I'm going to select the data create a chart with one keystroke, that's the F11 key and then right click and change the chart location back to be an object in the original worksheet.
Excel charts by default tend to look horrible.
I'm going to right click "format" "Plot area" choose "fill effects" and choose a "preset" gradient to add some color to the chart.
I could go through and do any other formatting that I wanted to do.
I want to get rid of the border around the outside of the chart.
So I'm going to click somewhere in the white space.
When I click in the white space, I've selected the whole chart.
And now Ctrl 1 will take me to format the chart area and I can say that I want a border of none.
Click ok.
Now I still have the entire chart selected. If I would accidentally unselect that I want to click on the chart but in the white space to select the whole chart.
Ctrl C to copy and I'll switch over to pwerpoint. I've inserted a new slide and change the slide layout to just be a title at the top with nothing else and now we're going to go to "Edit" "Paste special" and paste this as a picture.
Click "OK" and you'll see that we now get the chart without the border.
I'm able to resize it as necessary to make it fill up the chart.
Now the reason that I paste as picture.
If I just use edit paste, it brings the chart, but it also brings the entire workbook along.
So let's say I had 20 worksheets each with different work papers maybe some confidential information.
If I would just paste that to powepoint, someone won't be able to double click on the chart and see all of the work papers behind the chart. To keep the file size small and also for privacy reasons.
I want to copy the chart and use "Edit" "Paste special" "Paste as picture" to make sure that I just bring the chart along.
So there you go. There's a question from Bob in Dallas how to take a chart for excel and move it over to powerpoint, if for some reason you need to use powerpoint instead of excel.
Thanks for stopping by. We'll see you next time for another netcast from MrExcel.
Today we have a question sent in by Bob from Dallas.
Bob is interested in taking a chart from excel and pasting it over to powerpoint.
Now I know that we use excel for everything but occasionally sometimes we have to go outside of excel and microsoft has provided some great little add-in tools that work well with excel and today we're going to learn how to take a chart from excel over to that another little add-in called powerpoint.
So I have some data here in excel.
I'm going to select the data create a chart with one keystroke, that's the F11 key and then right click and change the chart location back to be an object in the original worksheet.
Excel charts by default tend to look horrible.
I'm going to right click "format" "Plot area" choose "fill effects" and choose a "preset" gradient to add some color to the chart.
I could go through and do any other formatting that I wanted to do.
I want to get rid of the border around the outside of the chart.
So I'm going to click somewhere in the white space.
When I click in the white space, I've selected the whole chart.
And now Ctrl 1 will take me to format the chart area and I can say that I want a border of none.
Click ok.
Now I still have the entire chart selected. If I would accidentally unselect that I want to click on the chart but in the white space to select the whole chart.
Ctrl C to copy and I'll switch over to pwerpoint. I've inserted a new slide and change the slide layout to just be a title at the top with nothing else and now we're going to go to "Edit" "Paste special" and paste this as a picture.
Click "OK" and you'll see that we now get the chart without the border.
I'm able to resize it as necessary to make it fill up the chart.
Now the reason that I paste as picture.
If I just use edit paste, it brings the chart, but it also brings the entire workbook along.
So let's say I had 20 worksheets each with different work papers maybe some confidential information.
If I would just paste that to powepoint, someone won't be able to double click on the chart and see all of the work papers behind the chart. To keep the file size small and also for privacy reasons.
I want to copy the chart and use "Edit" "Paste special" "Paste as picture" to make sure that I just bring the chart along.
So there you go. There's a question from Bob in Dallas how to take a chart for excel and move it over to powerpoint, if for some reason you need to use powerpoint instead of excel.
Thanks for stopping by. We'll see you next time for another netcast from MrExcel.
