Excel Chart Tip: Create a graph in PowerPoint using data from Excel

[@justinritter9303]

when you are doing a college project last minute (this vid came in clutch!)

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@Rono.t]

man same

[@seansmith1405]

I appreciate how straightforward this was. Thanks!

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@josephbrolly7232]

Straight to the point. Love it

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful

[@mihiriuyangoda4913]

Crystal clear and perfect for beginners.

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@felicianacardoza1318]

i cant get the chart

[@alexpmez]

Very clear, straight to the point, Thanks!

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@Sandeep2463]

straight to the point. excellent

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@YettyJane]

Very straightforward Thanks

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@lappletony1]

simple & concise --thank you

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@satyamrai2577]

Quick and helpful!

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@carolinemarangu8174]

Learnt something new. Thank you.

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@ShaniqueNcube]

Thank you so much ❤

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@sayednuruddin2633]

AWESOME, THANK YOU

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@brettbuffington3636]

Thanks! Explained simply.

[@ThinkOutsideTheSlide]

Glad it was helpful!

[@maxpayne5007]

Thank you for the help.

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful

[@AnugwelemOnyinyechiFavour-f5i]

Thanks for teaching me, am great full

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@inameleo]

Thanks for the clarification

[@ThinkOutsideTheSlide]

Glad you found the video helpful

[@segbefiakwaku2772]

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.

[@Lainey190-y1f]

Thank you, this was very helpful.

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@LauraGarcia-gq3ru]

Thank you so much!

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@vk9h]

Well done!

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@omotolaniadeyemi]

Very educative

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@ovieabolor6057]

Very helpful

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@sgluxhomes]

Very clear. Subscribed. How do I show the values at the top of each bar?

[@ThinkOutsideTheSlide]

Since PowerPoint's graphing is the same as Excel, you can add data labels to show the values at the top of the columns.

[@christiandelatorre4096]

is this a graphic presentation?

[@RupKBK]

very very helpful.

[@tutsecret499]

Thank you.

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful

[@statistico897]

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!

[@ThinkOutsideTheSlide]

No it is not. PowerPoint does not allow you to change the default animation order of categories for a chart.

[@sharmistha19]

How to paste multiple same type of chart with each different embed worksheet?

[@JesseEdwards-x7i]

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

[@ThinkOutsideTheSlide]

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: kzbin.info/www/bejne/a2nRnn5ohr10b8U.

[@heidimargulius8211]

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!

[@ThinkOutsideTheSlide]

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.

[@heidimargulius8211]

@@ThinkOutsideTheSlide Thanks!

[@josec.6536]

How do I link those data with Excel?

[@ThinkOutsideTheSlide]

If you want to link an Excel chart to a PowerPoint slide follow the steps in this video: kzbin.info/www/bejne/f5OyiKhtg9B5r68

[@pranetapatel2702]

Thanks

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@eugene9353]

What to do, if the chart isn t opening automatically ?

[@tojere_101]

i don't have the "chart" option :(

[@osmocutie]

thanks

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@specialimoekor6651]

Impactful

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@wahiduzzaman5079]

So easy

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.

[@tutsecret499]

Which option you most prefer and the chart creation inside or the link method? Which option offers better advantage?

[@ofeaghomatse3424]

Nice1

[@salinimohapatra7543]

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.

[@ThinkOutsideTheSlide]

I believe you can. If each chart referenced the same data cells, once those cells are updated, all of the charts would update.

[@heroualfawzi6679]

Thank you. It was so helpful

[@ThinkOutsideTheSlide]

I'm glad you found the video helpful.