How to Make a Pie Chart in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ธ.ค. 2024

ความคิดเห็น • 104

  • @KevinStratvert
    @KevinStratvert  3 ปีที่แล้ว +11

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

  • @1968Bike
    @1968Bike ปีที่แล้ว +7

    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!

  • @annmareewilliams3218
    @annmareewilliams3218 2 ปีที่แล้ว +5

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

  • @fosscraft1431
    @fosscraft1431 3 ปีที่แล้ว +3

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

  • @sarahalmanie6506
    @sarahalmanie6506 4 ปีที่แล้ว +64

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

    • @abiieditz8080
      @abiieditz8080 4 ปีที่แล้ว +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 10 หลายเดือนก่อน

      @@danieldumitru2349 thanks

    • @XiaoPangZi
      @XiaoPangZi 8 หลายเดือนก่อน

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

  • @edithalicea9638
    @edithalicea9638 ปีที่แล้ว +5

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

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

  • @ranjansarker1640
    @ranjansarker1640 3 ปีที่แล้ว +6

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

  • @mgr001
    @mgr001 3 หลายเดือนก่อน

    Look no further, Kevin nails it.... as usual

  • @CCCameron-w8m
    @CCCameron-w8m 9 หลายเดือนก่อน

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

  • @anikamehreen2620
    @anikamehreen2620 2 ปีที่แล้ว

    really grateful as you uploaded the file

  • @markhackney3305
    @markhackney3305 3 ปีที่แล้ว +3

    Thanks Kevin, very nice guide, noob friendly and concise

  • @jasonstites1576
    @jasonstites1576 2 ปีที่แล้ว +2

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

  • @KelebogileMabe-pp2qb
    @KelebogileMabe-pp2qb ปีที่แล้ว

    thank you so much this really helped not gonna lie.

  • @chicagomike
    @chicagomike ปีที่แล้ว +1

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

  • @aviesakura1
    @aviesakura1 3 ปีที่แล้ว +2

    What exactly I'm looking for! Thank you.

  • @adaywithandrea13
    @adaywithandrea13 7 หลายเดือนก่อน

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

  • @arlenefeliciano8066
    @arlenefeliciano8066 2 ปีที่แล้ว +2

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

  • @261mrbrown
    @261mrbrown 3 ปีที่แล้ว +1

    Great Job.. Thanks

  • @hyperlow6401
    @hyperlow6401 7 หลายเดือนก่อน

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

  • @kavithanaveen1124
    @kavithanaveen1124 ปีที่แล้ว

    Ty for easy explanation

  • @williamfaulkner1959
    @williamfaulkner1959 3 ปีที่แล้ว

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

  • @DerechoMegara12
    @DerechoMegara12 ปีที่แล้ว

    Great video!

  • @marie-anneduarte4981
    @marie-anneduarte4981 4 ปีที่แล้ว +1

    Thank you very much. I have learned something today.

  • @hanaru8564
    @hanaru8564 4 ปีที่แล้ว +3

    This was really helpful!
    thank you sooo much

  • @gariaber5934
    @gariaber5934 2 ปีที่แล้ว

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

  • @DenaturedProtein
    @DenaturedProtein ปีที่แล้ว

    Thanks Man!

  • @Hermetic_
    @Hermetic_ ปีที่แล้ว

    Awesome. Thanks 🙏

  • @rng_epic2634
    @rng_epic2634 3 ปีที่แล้ว

    tysm wish you the best of luck my dude

  • @mohamedklileche7382
    @mohamedklileche7382 2 ปีที่แล้ว

    highly informative, thanks for sharing

  • @emmanhoobs777IHE
    @emmanhoobs777IHE ปีที่แล้ว

    Wow i learnt alot

  • @user-tc5pl3zw3h
    @user-tc5pl3zw3h 9 หลายเดือนก่อน +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.

  • @ΒασίληςΤσιάρας-β2ν
    @ΒασίληςΤσιάρας-β2ν ปีที่แล้ว

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

  • @jannd6577
    @jannd6577 8 หลายเดือนก่อน

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

  • @FoulVamp
    @FoulVamp ปีที่แล้ว

    Thanks for helping me with my math homework lol

  • @kiransinanan1116
    @kiransinanan1116 10 หลายเดือนก่อน

    Very helpful

  • @1128zoe
    @1128zoe 4 ปีที่แล้ว +2

    Thank you so much! Please upload more!

  • @Viewingpublic08
    @Viewingpublic08 4 ปีที่แล้ว +5

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

  • @FaysalEasyExcel
    @FaysalEasyExcel 4 ปีที่แล้ว +3

    good video kevin.

  • @furiousruffian6041
    @furiousruffian6041 4 ปีที่แล้ว +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 4 ปีที่แล้ว

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

    • @furiousruffian6041
      @furiousruffian6041 4 ปีที่แล้ว

      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

  • @gracemayberry5753
    @gracemayberry5753 2 ปีที่แล้ว

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

  • @farhadaliyev6962
    @farhadaliyev6962 4 ปีที่แล้ว +2

    Thank you very much!

  • @roseyap8523
    @roseyap8523 ปีที่แล้ว

    good tutorial

  • @CriminologistRWorst
    @CriminologistRWorst 4 ปีที่แล้ว +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

  • @ela4la
    @ela4la 2 ปีที่แล้ว

    Thank you! 📊✅

  • @yogendrahirani1598
    @yogendrahirani1598 3 หลายเดือนก่อน

    wow! Great

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

  • @adicus1110
    @adicus1110 4 ปีที่แล้ว +1

    Really helpful, thanks.

  • @davebenner3276
    @davebenner3276 4 หลายเดือนก่อน

    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?

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

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

  • @nackedtony1977
    @nackedtony1977 3 ปีที่แล้ว

    interesing video.

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

  • @robertjustice8267
    @robertjustice8267 5 หลายเดือนก่อน

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

  • @charityobeng7277
    @charityobeng7277 8 หลายเดือนก่อน

    nice video, but wanted a demonstration with higher dimensional table. just two columns did not 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

  • @josipdrazenovic2475
    @josipdrazenovic2475 2 ปีที่แล้ว +1

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

  • @huntergamingaman.5828
    @huntergamingaman.5828 4 ปีที่แล้ว +1

    Good video

  • @kaybobbitt7787
    @kaybobbitt7787 ปีที่แล้ว

    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

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

  • @jonassivickis3395
    @jonassivickis3395 ปีที่แล้ว

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

  • @Amandangubane-he4xh
    @Amandangubane-he4xh 6 หลายเดือนก่อน

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

  • @surbanoclarabel5544
    @surbanoclarabel5544 ปีที่แล้ว

    Thank youu

  • @lupitacontreras9362
    @lupitacontreras9362 10 หลายเดือนก่อน

    Bro just go to the point

  • @micronesia3797
    @micronesia3797 9 หลายเดือนก่อน

    Is there a way to group data categories?

  • @JWN154
    @JWN154 ปีที่แล้ว

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

  • @jacobruiz4287
    @jacobruiz4287 9 หลายเดือนก่อน

    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?

  • @ayayahya6430
    @ayayahya6430 ปีที่แล้ว

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

  • @greyngreyer5
    @greyngreyer5 ปีที่แล้ว

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

  • @ShantaviaMckenzie-g4z
    @ShantaviaMckenzie-g4z 10 หลายเดือนก่อน

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

  • @aurae_279
    @aurae_279 3 ปีที่แล้ว +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?

  • @renugas3162
    @renugas3162 3 ปีที่แล้ว

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

  • @estherhanzlik2726
    @estherhanzlik2726 4 ปีที่แล้ว

    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.

  • @ruparai2142
    @ruparai2142 4 ปีที่แล้ว

    Thank you so much

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

  • @abdulghaffar4563
    @abdulghaffar4563 2 ปีที่แล้ว +1

    Wow

  • @jnhnmk
    @jnhnmk 4 ปีที่แล้ว

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

  • @proffesionallisence839
    @proffesionallisence839 3 ปีที่แล้ว

    exelent

  • @rockxstarx4945
    @rockxstarx4945 3 ปีที่แล้ว

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

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

  • @kevincahill8207
    @kevincahill8207 4 ปีที่แล้ว

    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

  • @WebCEO-online-seo-tools
    @WebCEO-online-seo-tools ปีที่แล้ว

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

  • @nancyjackson9924
    @nancyjackson9924 ปีที่แล้ว +1

    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

  • @parksideucc
    @parksideucc ปีที่แล้ว

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

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

  • @pragyaa8853
    @pragyaa8853 4 ปีที่แล้ว

    hello

  • @farhadaliyev6962
    @farhadaliyev6962 4 ปีที่แล้ว +3

    : D

  • @mytoneshorts327
    @mytoneshorts327 2 ปีที่แล้ว

    Tumhara 100 diamond Dunga tu Mera TH-cam channel subscribe karoge to X ka radium bhi Dunga jaldi

  • @emmanuelokyere7452
    @emmanuelokyere7452 9 หลายเดือนก่อน

    Thank you so much