How to Make a Pie Chart in Excel

Поділитися
Вставка
  • Опубліковано 26 лип 2024
  • 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
    @KevinStratvert  3 роки тому +9

    🏫 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: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html

  • @annmareewilliams3218
    @annmareewilliams3218 Рік тому +5

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

  • @1968Bike
    @1968Bike Рік тому +5

    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!

  • @gracewalker7308
    @gracewalker7308 Рік тому +1

    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 Рік тому +5

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

  • @ranjansarker1640
    @ranjansarker1640 3 роки тому +6

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

  • @fosscraft1431
    @fosscraft1431 2 роки тому +3

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

  • @jasonstites1576
    @jasonstites1576 Рік тому +2

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

  • @markhackney3305
    @markhackney3305 2 роки тому +3

    Thanks Kevin, very nice guide, noob friendly and concise

  • @user-dr2es2hk5j
    @user-dr2es2hk5j 5 місяців тому

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

  • @hanaru8564
    @hanaru8564 3 роки тому +3

    This was really helpful!
    thank you sooo much

  • @1128zoe
    @1128zoe 4 роки тому +2

    Thank you so much! Please upload more!

  • @arlenefeliciano8066
    @arlenefeliciano8066 Рік тому +2

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

  • @aviesakura1
    @aviesakura1 3 роки тому +2

    What exactly I'm looking for! Thank you.

  • @chicagomike
    @chicagomike Рік тому +1

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

  • @adicus1110
    @adicus1110 4 роки тому +1

    Really helpful, thanks.

  • @marie-anneduarte4981
    @marie-anneduarte4981 3 роки тому +1

    Thank you very much. I have learned something today.

  • @farhadaliyev6962
    @farhadaliyev6962 4 роки тому +2

    Thank you very much!

  • @adaywithandrea13
    @adaywithandrea13 3 місяці тому

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

  • @gariaber5934
    @gariaber5934 2 роки тому

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

  • @sarahalmanie6506
    @sarahalmanie6506 4 роки тому +60

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

    • @abiieditz8080
      @abiieditz8080 3 роки тому +1

      @@Creig1 same

    • @danieldumitru2349
      @danieldumitru2349 3 роки тому +8

      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

  • @anikamehreen2620
    @anikamehreen2620 2 роки тому

    really grateful as you uploaded the file

  • @williamfaulkner1959
    @williamfaulkner1959 3 роки тому

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

  • @261mrbrown
    @261mrbrown 2 роки тому +1

    Great Job.. Thanks

  • @FaysalEasyExcel
    @FaysalEasyExcel 4 роки тому +3

    good video kevin.

  • @user-tc5pl3zw3h
    @user-tc5pl3zw3h 5 місяців тому +1

    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-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 !!!

  • @hyperlow6401
    @hyperlow6401 3 місяці тому

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

  • @rng_epic2634
    @rng_epic2634 3 роки тому

    tysm wish you the best of luck my dude

  • @KelebogileMabe-pp2qb
    @KelebogileMabe-pp2qb 9 місяців тому

    thank you so much this really helped not gonna lie.

  • @mohamedklileche7382
    @mohamedklileche7382 Рік тому

    highly informative, thanks for sharing

  • @kavithanaveen1124
    @kavithanaveen1124 9 місяців тому

    Ty for easy explanation

  • @ruparai2142
    @ruparai2142 4 роки тому

    Thank you so much

  • @brendamartinezgomez2297
    @brendamartinezgomez2297 10 місяців тому

    Great video!

  • @Hermetic_
    @Hermetic_ Рік тому

    Awesome. Thanks 🙏

  • @ela4la
    @ela4la 2 роки тому

    Thank you! 📊✅

  • @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

  • @kiransinanan1116
    @kiransinanan1116 5 місяців тому

    Very helpful

  • @DenaturedProtein
    @DenaturedProtein Рік тому

    Thanks Man!

  • @huntergamingaman.5828
    @huntergamingaman.5828 4 роки тому +1

    Good video

  • @furiousruffian6041
    @furiousruffian6041 3 роки тому +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

  • @Dedicated2WendyWilliams
    @Dedicated2WendyWilliams 4 роки тому +3

    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?

  • @user-vs3vs3rx7j
    @user-vs3vs3rx7j Рік тому

    Wow i learnt alot

  • @roseyap8523
    @roseyap8523 Рік тому

    good tutorial

  • @FoulVamp
    @FoulVamp Рік тому

    Thanks for helping me with my math homework lol

  • @jannd6577
    @jannd6577 4 місяці тому

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

  • @kaybobbitt7787
    @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

  • @Viewingpublic08
    @Viewingpublic08 3 роки тому +5

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

  • @josipdrazenovic2475
    @josipdrazenovic2475 2 роки тому +1

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

  • @nackedtony1977
    @nackedtony1977 3 роки тому

    interesing video.

  • @PreciousAfricanStoryz
    @PreciousAfricanStoryz Рік тому +1

    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

  • @CriminologistRWorst
    @CriminologistRWorst 3 роки тому +1

    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

  • @surbanoclarabel5544
    @surbanoclarabel5544 9 місяців тому

    Thank youu

  • @InASexyDimension
    @InASexyDimension 4 роки тому +3

    How do you sort and input the data?

  • @abdulghaffar4563
    @abdulghaffar4563 2 роки тому +1

    Wow

  • @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?

  • @raymondkemper8473
    @raymondkemper8473 3 роки тому +1

    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

  • @proffesionallisence839
    @proffesionallisence839 2 роки тому

    exelent

  • @robertjustice8267
    @robertjustice8267 Місяць тому

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

  • @jnhnmk
    @jnhnmk 3 роки тому

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

  • @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.

  • @gamaDliel
    @gamaDliel 3 роки тому +1

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

  • @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

  • @ayayahya6430
    @ayayahya6430 Рік тому

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

  • @charityobeng7277
    @charityobeng7277 4 місяці тому

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

  • @micronesia3797
    @micronesia3797 4 місяці тому

    Is there a way to group data categories?

  • @jonassivickis3395
    @jonassivickis3395 9 місяців тому

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

  • @greyngreyer5
    @greyngreyer5 Рік тому

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

  • @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

  • @lupitacontreras9362
    @lupitacontreras9362 6 місяців тому

    Bro just go to the point

  • @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?

  • @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.

  • @JWN154
    @JWN154 Рік тому

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

  • @user-ed3gb5cd7v
    @user-ed3gb5cd7v 6 місяців тому

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

  • @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

  • @excelworx8712
    @excelworx8712 4 роки тому +1

    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!

  • @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

  • @WebCEO-online-seo-tools
    @WebCEO-online-seo-tools Рік тому

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

  • @aurae_279
    @aurae_279 2 роки тому +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?

  • @rockxstarx4945
    @rockxstarx4945 3 роки тому

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

  • @parksideucc
    @parksideucc Рік тому

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

  • @farhadaliyev6962
    @farhadaliyev6962 4 роки тому +3

    : D

  • @pragyaa8853
    @pragyaa8853 3 роки тому

    hello

  • @Historian212
    @Historian212 3 роки тому +1

    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 UA-cam channel subscribe karoge to X ka radium bhi Dunga jaldi

  • @emmanuelokyere7452
    @emmanuelokyere7452 4 місяці тому

    Thank you so much