How to Make a Pie Chart in Excel

Рет қаралды 388,956

Күн бұрын

Learn how to create Pie Charts, Pie-in-Pie Charts, Doughnut Charts, and Pivot Pie Charts in this step-by-step tutorial video. At the end, I also show you how you can make Pie Charts for free using Excel on the web.
Here's the sheet I used if you want to follow along:
1drv.ms/x/s!AmxrofZZlZ-whId4w...
Interested in learning more about Pivot Tables? The following video walks through pivot tables in depth: • Pivot Table Excel Tuto...
Watch more Excel tutorial videos: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
As full-disclosure, I work at Microsoft as a full-time employee.

Пікірлер: 101

@KevinStratvert 3 жыл бұрын

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

@annmareewilliams3218 Жыл бұрын

This is brilliant I have to say Kevin you are so clear on everything and can hear you perfectly!!!

@edithalicea9638 Жыл бұрын

Love this guy! He makes every so easy and simple! Go Kevin!

@gracewalker7308 Жыл бұрын

Thank you sooo much. Excel has been so intimidating that I have NEVER attempted to use it.I just created my first Pie Chart in Excel, as a matter of fact, I just completed my first task in Excel. You made it so easy.

@aviesakura1 2 жыл бұрын

What exactly I'm looking for! Thank you.

@arlenefeliciano8066 Жыл бұрын

Hi Kevin!!! You are sooooo good explaining!!! Love it!! Thanks for your tutorials.

@markhackney3305 2 жыл бұрын

Thanks Kevin, very nice guide, noob friendly and concise

@1128zoe 4 жыл бұрын

Thank you so much! Please upload more!

@1968Bike Жыл бұрын

He is brilliant, I looked at least ten tutorials on pie charts and couldn’t figure it out. Once I came upon his video and guess what, I was able to create a pie chart in five minutes. So brilliantly explained. Thank you bud!

@foilovesyou9979 3 ай бұрын

Me too

@hanaru8564 3 жыл бұрын

This was really helpful! thank you sooo much

@fosscraft1431 2 жыл бұрын

thanks so much Kevin. i had to do homework and this video helped me so much. thank you!

@jasonstites1576 Жыл бұрын

Why did I make it so complicated for myself. Thank you for the walk through. 👍

@marie-anneduarte4981 3 жыл бұрын

Thank you very much. I have learned something today.

@gariaber5934 2 жыл бұрын

Great video. Can't wait to give it a try

@adicus1110 4 жыл бұрын

Really helpful, thanks.

@ranjansarker1640 3 жыл бұрын

Thank you, Kelvin. Your explanation is very nice and I understand it well.

@frostyfoxteals 2 жыл бұрын

*kevin lol

@sarahalmanie6506 3 жыл бұрын

Hi why when I make a pie chart it comes invisible😖?

@abiieditz8080 3 жыл бұрын

@@Creig1 same

@danieldumitru2349 3 жыл бұрын

You have to highlight the cells you want in the pie chart, then click the insert button. For example, on 2:28, you see how all the cell's he wants in the pie chart are selected?

@yiio5524 6 ай бұрын

@@danieldumitru2349 thanks

@XiaoPangZi 4 ай бұрын

@@danieldumitru2349when he clicks on the pie the cells are not selected

@anikamehreen2620 Жыл бұрын

really grateful as you uploaded the file

@chicagomike Жыл бұрын

Always a wonderful teacher! Hope you are doing well after departing Microsoft!

@adaywithandrea13 2 ай бұрын

Thank you this video was so helpful to organize my data!!

@williamfaulkner1959 3 жыл бұрын

I am now able to make charts. Thank you so much.

@farhadaliyev6962 4 жыл бұрын

Thank you very much!

@user-dr2es2hk5j 5 ай бұрын

So simple, so helpful. Thanks for explaining it in clear terms - makes it so easy for the amateur! LOL!

@rng_epic2634 3 жыл бұрын

tysm wish you the best of luck my dude

@mohamedklileche7382 Жыл бұрын

highly informative, thanks for sharing

@FaysalEasyExcel 4 жыл бұрын

good video kevin.

@261mrbrown 2 жыл бұрын

Great Job.. Thanks

@kavithanaveen1124 9 ай бұрын

Ty for easy explanation

@KelebogileMabe-pp2qb 8 ай бұрын

thank you so much this really helped not gonna lie.

@Hermetic_ Жыл бұрын

Awesome. Thanks 🙏

@DenaturedProtein Жыл бұрын

Thanks Man!

@brendamartinezgomez2297 10 ай бұрын

Great video!

@ela4la 2 жыл бұрын

Thank you! 📊✅

@hyperlow6401 2 ай бұрын

thank you, this video was helpful. because im rarely use excel

@emmanuelokyere7452 4 ай бұрын

Thank you so much

@kiransinanan1116 5 ай бұрын

Very helpful

@gracemayberry5753 Жыл бұрын

Thanks about the pie charts and the pivot help. This was great. Can you do anything on pivot charts in excel. Thank you

@user-tc5pl3zw3h 4 ай бұрын

Mmmm... You said "Doughnut pie"... I almost went into a diabetic coma when you said that. Just imagine it - a pie made of doughnuts.

@user-vs3vs3rx7j Жыл бұрын

Wow i learnt alot

@user-hj2rc3wm7w Жыл бұрын

You are astonishing!!! On a real note, you helped a lot with a project of mine so it was a no-brainer for me to not subscribe!!! THANKS A LOT !!!

@Viewingpublic08 3 жыл бұрын

You only had one cell selected and the chart still appeared with all the info in it. How did that happen?

@jannd6577 3 ай бұрын

I LOVED the pie chart tutorial, DO you have a Histogram Frequency distribution using day and time?

@roseyap8523 Жыл бұрын

good tutorial

@huntergamingaman.5828 4 жыл бұрын

Good video

@kaybobbitt7787 7 ай бұрын

Hi Kevin, What type of chart should I use to define different sections within a chart. i.e.Sales categoty: Home repair & then show it by vendor? Also, how would I set up my columns on the spreadsheet? thanks

@nackedtony1977 3 жыл бұрын

interesing video.

@Dedicated2WendyWilliams 4 жыл бұрын

Hey i was wondering i did what you said of how to create i pie chart, i did a mock up test last week, i had to creat a pie chart using data (from the test) and the pie chart was not showing up for some reason. Any tips?

@surbanoclarabel5544 9 ай бұрын

Thank youu

@josipdrazenovic2475 2 жыл бұрын

Hey Kevin, how do you insert pictures into the Online 365 Excel graphs? I cannot find the funciton.

@PreciousAfricanStoryz Жыл бұрын

Your tutorials are really helpfull to me thank you. But when I tried using the bar chat it didn’t come up like this just a dialogue box that came up. I use the 2016 Ms office version I don’t know why it didn’t come up this way. Thanks again

@InASexyDimension 3 жыл бұрын

How do you sort and input the data?

@FoulVamp Жыл бұрын

Thanks for helping me with my math homework lol

@robertjustice8267 19 күн бұрын

Is there a way to create "Budget Pie" where the sums exacted reveal percentages left over?

@deliagarcia5174 Жыл бұрын

I've found the videos very helpful. For the Office 365 for free it appears that you do not have access to all the excel features. Example you cannot customize your Quick access tool bar or get the same view of the pivot data in the purchased version. Is that correct?

@raymondkemper8473 3 жыл бұрын

In a chart +1,-3 should show up with the line going up 1 and down 3 ending 2 below the 0 line on a chat. How do I make this type chart

@CriminologistRWorst 3 жыл бұрын

Kevin, I noticed with other colleagues of mine inserting their company's letter head info, but does not appear while implementing your data. The letter head info appears when those who print copies...... How can insert my company's letterhead info and logo on my spreadsheet (first page) as a default, if applicable? Thank you Kevin, keep pumping that content. Learning more on your channel than "other" costumer service calls..... sssshhhhhh

@Amandangubane-he4xh Ай бұрын

How do you highlight in order for the pie chart appear word of sales person ,I'm am struggling using laptop

@furiousruffian6041 3 жыл бұрын

Hello Kevin, I love your work, and greatly appreciate. Request, if you could help create a video on creating "half indicator" using donut chart. It will be very helpful.

@furiousruffian6041 3 жыл бұрын

Yet, another video could possibly be on creating "Heat Map" using horizontal bar chart. Many thanks

@furiousruffian6041 3 жыл бұрын

The example data is as follows: Col A = Name's Col B = Subject 1 Col C = Subject 2 Col D = Subject 3 Col E = Total of 1, 2, and 3

@proffesionallisence839 2 жыл бұрын

exelent

@micronesia3797 4 ай бұрын

Is there a way to group data categories?

@jnhnmk 3 жыл бұрын

Can you help how to compere program language evolution using excel chart please

@jonassivickis3395 9 ай бұрын

Is it possible to split information more than one time in the same pie chart?

@ayayahya6430 Жыл бұрын

Am I able to do Pie chart for status (complete, to do, In progress)?

@gamaDliel 3 жыл бұрын

i have more than 2 columns....kinda confused on how to edit the info that goes into the pie chart

@estherhanzlik2726 3 жыл бұрын

Hi, HELP! I followed your instructions for a Pivot Chart, selecting five columns. Unfortunately a window pops up "This window requires at least two rows of source data. You cannot use a command on a selection in only one row. Try the following: If you're using an advance filter, select a range of cells that contains at least two rows of data. Then click the AD." I'm completely lost :(m please help.

@jacobruiz4287 4 ай бұрын

What were to happen if I had repeating categories like let’s say if the name John came up in your data five times. How would you make the pie chart combine John’s earnings?

@JWN154 Жыл бұрын

If you decide to use the column chart, how do you make it easier to read the revenue? Everything merges together hard to read

@greyngreyer5 Жыл бұрын

How do I do pie chart for percentage of representation in a column?

@abdulghaffar4563 2 жыл бұрын

Wow

@JWN154 Жыл бұрын

When I click data my option highest to lowest isint high lighted. NeverMind I got it

@user-ed3gb5cd7v 5 ай бұрын

What if my pie chart not appearing correctly what am I doing wrong?

@charityobeng7277 3 ай бұрын

nice video, but wanted a demonstration with higher dimensional table. just two columns did not help

@lupitacontreras9362 5 ай бұрын

Bro just go to the point

@loidaawuor6193 Жыл бұрын

Can you make a video on how to insert information from excel to word? Am not talking about copy and paste. Like how you can do mailing from data in Excell and using that information in word. E.g when drafting a letter of performance per every employee extracting the data keyed in Excell to draft the letter, addressing it to individual employees. I will really appreciate a tuitorial on that. Thanks in advance.

@renugas3162 2 жыл бұрын

But Kelvin Bro, My problem is Only the text are display And the pie chart is not dispaly Please help me bro

@aurae_279 2 жыл бұрын

Hello, great video. Great explanation, but one thing is that when i create a pie chart on the online version, it only has a title, and no chart. do you know what is going on?

@martaosite8275 2 жыл бұрын

same

@WebCEO-online-seo-tools Жыл бұрын

How do you delete a pie chart gone wrong? ;) I don't see that option

@kevincahill8207 3 жыл бұрын

Kevin, How do I add a slice to my pie chart

@johnmor3541 3 жыл бұрын

If you data is formatted as a table it should automatically add a slice when a new row of data is entered

@rockxstarx4945 3 жыл бұрын

When I right click on the pie chart that doesn't come up

@excelworx8712 4 жыл бұрын

Hi Kevin. You could have gone just one more step on the pivot pie chart by explaining that filters automatically changes the chart. But good video, all the same!

@parksideucc Жыл бұрын

Looks so easy, but my pie chart box is empty every time.

@pragyaa8853 3 жыл бұрын

hello

@nancyjackson9924 8 ай бұрын

You assume we know how to get the information onto the chart. I have watched several of your videos, and they all start after the information has been entered. I despise Excel because it is so hard to get information on there to make any sense

@farhadaliyev6962 4 жыл бұрын

: D