Excel Chart Tip: Create a graph in PowerPoint using data from Excel
ฝัง
- เผยแพร่เมื่อ 13 ส.ค. 2019
- Welcome to another Excel Chart Tips video. These videos are inspired by the work I do with business professionals to visually communicate financial results and analysis as well as the forum posts I answer from users on MrExcel.com.
In this video I show how to add a graph to a PowerPoint slide by creating the graph in PowerPoint using data copied from an Excel worksheet. There is no link between the data in the Excel worksheet and the PowerPoint slide. In the video I am using Excel 365 on Windows 10, and most modern versions of Excel will look very similar. If you like the video, please subscribe to the channel and add a comment below.
If you want to learn what you should do to create presentation-ready Excel charts that are easy to update and re-use, sign up for my free mini-course at thinkoutsidetheslide.teachabl....
If you want quickly learn expert-level Excel techniques to create presentation-ready charts that are easy to update and re-use without programming, add-ins, or web tools, check out my Excel Chart Skills 501 course at thinkoutsidetheslide.teachabl....
You can access the entire playlist of Excel Chart Tips videos at www.ExcelChartTips.com.
when you are doing a college project last minute (this vid came in clutch!)
I'm glad you found the video helpful.
This video hasn't gotten enough recognition. Major thanks
You are welcome. I'm glad you found the video helpful.
Very clear, straight to the point, Thanks!
I'm glad you found the video helpful.
Thank you so much ❤
I'm glad you found the video helpful.
I appreciate how straightforward this was. Thanks!
I'm glad you found the video helpful.
Thanks! Explained simply.
Glad it was helpful!
Crystal clear and perfect for beginners.
I'm glad you found the video helpful.
Thank you, this was very helpful.
I'm glad you found the video helpful.
Straight to the point. Love it
I'm glad you found the video helpful
Very educative
I'm glad you found the video helpful.
Well done!
I'm glad you found the video helpful.
Learnt something new. Thank you.
I'm glad you found the video helpful.
very very helpful.
Thank you. It was so helpful
I'm glad you found the video helpful.
Thank so much. this is very useful. how do I show multiple amounts as data labels on the same bar, for instance both dollar amount and pounds amount.
Very straightforward
Thanks
I'm glad you found the video helpful.
Thank you for the help.
I'm glad you found the video helpful
Thanks for the clarification
Glad you found the video helpful
straight to the point. excellent
I'm glad you found the video helpful.
AWESOME, THANK YOU
I'm glad you found the video helpful.
Thank you so much!
I'm glad you found the video helpful.
Very clear. Subscribed. How do I show the values at the top of each bar?
Since PowerPoint's graphing is the same as Excel, you can add data labels to show the values at the top of the columns.
Thank you.
I'm glad you found the video helpful
How to paste multiple same type of chart with each different embed worksheet?
is this a graphic presentation?
Is it possible to force powerpoint to display animated columns charts bars starting from right to left i.e. from the low to the high? Thanks!
No it is not. PowerPoint does not allow you to change the default animation order of categories for a chart.
Thanks
I'm glad you found the video helpful.
So easy
I'm glad you found the video helpful.
Impactful
I'm glad you found the video helpful.
Which option you most prefer and the chart creation inside or the link method? Which option offers better advantage?
Nice1
I have a question. I have created a few charts in PowerPoint using this method. However, the PPT is being shared and edited by multiple people in remote locations. I just received the PPT back and I need to make edits to a chart someone else inserted. When I went to "edit data in excel", Excel gives me an alert telling me it can't find the base xlsx file and is it possible it was moved, renamed, or deleted? Then Powerpoint gives me a similar alert telling me the linked file isn't available because it has been moved or hasn't been saved. It recommends embedding the data instead of linking in order to avoid this error. How did I end up here? Does this mean that the other user created the chart in excel and then copied and pasted it into PPT rather than creating it natively in PPT and that when I try to edit it, it is looking for the user's base file? I recreated the chart in PPT but now when I send it back, will THAT user have trouble editing the chart because there is a linked file saved to MY computer? How can I make sure the chart is using embedded data? Thanks!
You are correct that it is likely that the other user created the chart in Excel and used the regular copy & paste method to insert the chart into the slide. This method creates a link to the data in the original Excel file and does not copy the data into the PowerPoint file. So when you want to edit the data, the data is not found because it is in an Excel file on that other person's computer. When you create the chart in PowerPoint, the data is always in the PowerPoint file so anyone who has the file can update the chart. I would suggest you ask the others to only create the charts in PowerPoint using the technique in the video so that everyone can edit all the charts if needed.
@@ThinkOutsideTheSlide Thanks!
What if the data from excel is larger than the pre formatted data in power point?
I’m struggling with creating a chart to show more data
You can paste in more data than the default data for a PowerPoint graph. In fact, you can paste in data and formulas. This video shows you how: th-cam.com/video/58nmK2QXA9c/w-d-xo.html.
What to do, if the chart isn t opening automatically ?
i don't have the "chart" option :(
How do I link those data with Excel?
If you want to link an Excel chart to a PowerPoint slide follow the steps in this video: th-cam.com/video/IbOWu7NkFyM/w-d-xo.html
Hi, Is it possible to create different charts using one excel worksheet with different data points. So basically , instead of going to each chart to change the data every week, can i have one excel file with all charts data together where all i need to do every week is to go to that 1 excel file and do the changes and eventually all charts will be updated.
I believe you can. If each chart referenced the same data cells, once those cells are updated, all of the charts would update.