How to Make a Pie Chart in Excel

  Рет қаралды 393,243

Kevin Stratvert

Kevin Stratvert

Күн бұрын

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.

Пікірлер: 102
@KevinStratvert
@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: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@annmareewilliams3218
@annmareewilliams3218 Жыл бұрын
This is brilliant I have to say Kevin you are so clear on everything and can hear you perfectly!!!
@1968Bike
@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
@foilovesyou9979 3 ай бұрын
Me too
@gracewalker7308
@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.
@edithalicea9638
@edithalicea9638 Жыл бұрын
Love this guy! He makes every so easy and simple! Go Kevin!
@arlenefeliciano8066
@arlenefeliciano8066 Жыл бұрын
Hi Kevin!!! You are sooooo good explaining!!! Love it!! Thanks for your tutorials.
@markhackney3305
@markhackney3305 2 жыл бұрын
Thanks Kevin, very nice guide, noob friendly and concise
@fosscraft1431
@fosscraft1431 2 жыл бұрын
thanks so much Kevin. i had to do homework and this video helped me so much. thank you!
@hanaru8564
@hanaru8564 4 жыл бұрын
This was really helpful! thank you sooo much
@ranjansarker1640
@ranjansarker1640 3 жыл бұрын
Thank you, Kelvin. Your explanation is very nice and I understand it well.
@frostyfoxteals
@frostyfoxteals 2 жыл бұрын
*kevin lol
@aviesakura1
@aviesakura1 3 жыл бұрын
What exactly I'm looking for! Thank you.
@1128zoe
@1128zoe 4 жыл бұрын
Thank you so much! Please upload more!
@chicagomike
@chicagomike Жыл бұрын
Always a wonderful teacher! Hope you are doing well after departing Microsoft!
@jasonstites1576
@jasonstites1576 Жыл бұрын
Why did I make it so complicated for myself. Thank you for the walk through. 👍
@marie-anneduarte4981
@marie-anneduarte4981 3 жыл бұрын
Thank you very much. I have learned something today.
@adicus1110
@adicus1110 4 жыл бұрын
Really helpful, thanks.
@gariaber5934
@gariaber5934 2 жыл бұрын
Great video. Can't wait to give it a try
@farhadaliyev6962
@farhadaliyev6962 4 жыл бұрын
Thank you very much!
@williamfaulkner1959
@williamfaulkner1959 3 жыл бұрын
I am now able to make charts. Thank you so much.
@user-dr2es2hk5j
@user-dr2es2hk5j 5 ай бұрын
So simple, so helpful. Thanks for explaining it in clear terms - makes it so easy for the amateur! LOL!
@FaysalEasyExcel
@FaysalEasyExcel 4 жыл бұрын
good video kevin.
@anikamehreen2620
@anikamehreen2620 2 жыл бұрын
really grateful as you uploaded the file
@adaywithandrea13
@adaywithandrea13 3 ай бұрын
Thank you this video was so helpful to organize my data!!
@rng_epic2634
@rng_epic2634 3 жыл бұрын
tysm wish you the best of luck my dude
@261mrbrown
@261mrbrown 2 жыл бұрын
Great Job.. Thanks
@mohamedklileche7382
@mohamedklileche7382 Жыл бұрын
highly informative, thanks for sharing
@sarahalmanie6506
@sarahalmanie6506 4 жыл бұрын
Hi why when I make a pie chart it comes invisible😖?
@abiieditz8080
@abiieditz8080 3 жыл бұрын
@@Creig1 same
@danieldumitru2349
@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
@yiio5524 6 ай бұрын
@@danieldumitru2349 thanks
@XiaoPangZi
@XiaoPangZi 4 ай бұрын
@@danieldumitru2349when he clicks on the pie the cells are not selected
@gracemayberry5753
@gracemayberry5753 Жыл бұрын
Thanks about the pie charts and the pivot help. This was great. Can you do anything on pivot charts in excel. Thank you
@ruparai2142
@ruparai2142 4 жыл бұрын
Thank you so much
@kavithanaveen1124
@kavithanaveen1124 9 ай бұрын
Ty for easy explanation
@user-tc5pl3zw3h
@user-tc5pl3zw3h 5 ай бұрын
Mmmm... You said "Doughnut pie"... I almost went into a diabetic coma when you said that. Just imagine it - a pie made of doughnuts.
@brendamartinezgomez2297
@brendamartinezgomez2297 10 ай бұрын
Great video!
@Hermetic_
@Hermetic_ Жыл бұрын
Awesome. Thanks 🙏
@KelebogileMabe-pp2qb
@KelebogileMabe-pp2qb 9 ай бұрын
thank you so much this really helped not gonna lie.
@user-hj2rc3wm7w
@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 !!!
@Dedicated2WendyWilliams
@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?
@ela4la
@ela4la 2 жыл бұрын
Thank you! 📊✅
@hyperlow6401
@hyperlow6401 3 ай бұрын
thank you, this video was helpful. because im rarely use excel
@jannd6577
@jannd6577 4 ай бұрын
I LOVED the pie chart tutorial, DO you have a Histogram Frequency distribution using day and time?
@DenaturedProtein
@DenaturedProtein Жыл бұрын
Thanks Man!
@kiransinanan1116
@kiransinanan1116 6 ай бұрын
Very helpful
@Viewingpublic08
@Viewingpublic08 3 жыл бұрын
You only had one cell selected and the chart still appeared with all the info in it. How did that happen?
@huntergamingaman.5828
@huntergamingaman.5828 4 жыл бұрын
Good video
@PreciousAfricanStoryz
@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
@InASexyDimension 4 жыл бұрын
How do you sort and input the data?
@furiousruffian6041
@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
@furiousruffian6041 3 жыл бұрын
Yet, another video could possibly be on creating "Heat Map" using horizontal bar chart. Many thanks
@furiousruffian6041
@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
@CriminologistRWorst
@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
@kaybobbitt7787
@kaybobbitt7787 8 ай бұрын
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
@user-vs3vs3rx7j
@user-vs3vs3rx7j Жыл бұрын
Wow i learnt alot
@roseyap8523
@roseyap8523 Жыл бұрын
good tutorial
@surbanoclarabel5544
@surbanoclarabel5544 9 ай бұрын
Thank youu
@nackedtony1977
@nackedtony1977 3 жыл бұрын
interesing video.
@josipdrazenovic2475
@josipdrazenovic2475 2 жыл бұрын
Hey Kevin, how do you insert pictures into the Online 365 Excel graphs? I cannot find the funciton.
@raymondkemper8473
@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
@jnhnmk
@jnhnmk 3 жыл бұрын
Can you help how to compere program language evolution using excel chart please
@deliagarcia5174
@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?
@FoulVamp
@FoulVamp Жыл бұрын
Thanks for helping me with my math homework lol
@davebenner3276
@davebenner3276 2 күн бұрын
Thank you for your time. My data in my spreadsheet that i want to chart are not in contiguous cells. Can i select each cell one at a time?
@gamaDliel
@gamaDliel 3 жыл бұрын
i have more than 2 columns....kinda confused on how to edit the info that goes into the pie chart
@greyngreyer5
@greyngreyer5 Жыл бұрын
How do I do pie chart for percentage of representation in a column?
@robertjustice8267
@robertjustice8267 Ай бұрын
Is there a way to create "Budget Pie" where the sums exacted reveal percentages left over?
@jonassivickis3395
@jonassivickis3395 9 ай бұрын
Is it possible to split information more than one time in the same pie chart?
@abdulghaffar4563
@abdulghaffar4563 2 жыл бұрын
Wow
@ayayahya6430
@ayayahya6430 Жыл бұрын
Am I able to do Pie chart for status (complete, to do, In progress)?
@micronesia3797
@micronesia3797 5 ай бұрын
Is there a way to group data categories?
@JWN154
@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
@proffesionallisence839
@proffesionallisence839 2 жыл бұрын
exelent
@estherhanzlik2726
@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.
@Amandangubane-he4xh
@Amandangubane-he4xh 2 ай бұрын
How do you highlight in order for the pie chart appear word of sales person ,I'm am struggling using laptop
@loidaawuor6193
@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.
@lupitacontreras9362
@lupitacontreras9362 6 ай бұрын
Bro just go to the point
@JWN154
@JWN154 Жыл бұрын
When I click data my option highest to lowest isint high lighted. NeverMind I got it
@kevincahill8207
@kevincahill8207 3 жыл бұрын
Kevin, How do I add a slice to my pie chart
@johnmor3541
@johnmor3541 3 жыл бұрын
If you data is formatted as a table it should automatically add a slice when a new row of data is entered
@jacobruiz4287
@jacobruiz4287 5 ай бұрын
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?
@user-ed3gb5cd7v
@user-ed3gb5cd7v 6 ай бұрын
What if my pie chart not appearing correctly what am I doing wrong?
@aurae_279
@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
@martaosite8275 2 жыл бұрын
same
@charityobeng7277
@charityobeng7277 4 ай бұрын
nice video, but wanted a demonstration with higher dimensional table. just two columns did not help
@renugas3162
@renugas3162 2 жыл бұрын
But Kelvin Bro, My problem is Only the text are display And the pie chart is not dispaly Please help me bro
@rockxstarx4945
@rockxstarx4945 3 жыл бұрын
When I right click on the pie chart that doesn't come up
@excelworx8712
@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!
@WebCEO-online-seo-tools
@WebCEO-online-seo-tools Жыл бұрын
How do you delete a pie chart gone wrong? ;) I don't see that option
@parksideucc
@parksideucc Жыл бұрын
Looks so easy, but my pie chart box is empty every time.
@pragyaa8853
@pragyaa8853 3 жыл бұрын
hello
@farhadaliyev6962
@farhadaliyev6962 4 жыл бұрын
: D
@Historian212
@Historian212 3 жыл бұрын
Dude, we came here to learn how to make a pie chart. You don't need to explain to us why it's good to make a pie chart.
@nancyjackson9924
@nancyjackson9924 9 ай бұрын
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
@mytoneshorts327
@mytoneshorts327 Жыл бұрын
Tumhara 100 diamond Dunga tu Mera KZbin channel subscribe karoge to X ka radium bhi Dunga jaldi
@emmanuelokyere7452
@emmanuelokyere7452 5 ай бұрын
Thank you so much
Creating Pie Charts in Excel
11:37
Technology for Teachers and Students
Рет қаралды 45 М.
How to Create Pivot Table in Excel
20:49
Kevin Stratvert
Рет қаралды 1,1 МЛН
Summer shower by Secret Vlog
00:17
Secret Vlog
Рет қаралды 13 МЛН
Useful gadget for styling hair 🤩💖 #gadgets #hairstyle
00:20
FLIP FLOP Hacks
Рет қаралды 10 МЛН
How to Make a Pie chart in Microsoft Word
5:05
Office Master Tutorials
Рет қаралды 58 М.
Make Impressive McKinsey Visuals in Excel!
16:47
Kenji Explains
Рет қаралды 283 М.
Doughnut Pie Chart in Excel - Infographic
19:11
Haider Niaz
Рет қаралды 262 М.
Infographics: Progress Circle Chart in Excel
12:29
PK: An Excel Expert
Рет қаралды 1,1 МЛН
How to use Power Pivot in Excel | Full Tutorial
30:38
Kevin Stratvert
Рет қаралды 1,4 МЛН
Create a Pie of Pie Chart to Show Details Within a Data Value
4:43
Six Minutes. Smarter.
Рет қаралды 70 М.
Частая ошибка геймеров? 😐 Dareu A710X
1:00
Вэйми
Рет қаралды 4,2 МЛН
8 Товаров с Алиэкспресс, о которых ты мог и не знать!
49:47
РасПаковка ДваПаковка
Рет қаралды 171 М.
İĞNE İLE TELEFON TEMİZLEMEK!🤯
0:17
Safak Novruz
Рет қаралды 1,6 МЛН
КРУТОЙ ТЕЛЕФОН
0:16
KINO KAIF
Рет қаралды 6 МЛН