How to Make a Pie Chart in Excel

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

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

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

    🏫 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 ปีที่แล้ว +6

    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!

  • @mgr001
    @mgr001 2 วันที่ผ่านมา

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

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

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

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

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

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

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

    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 7 หลายเดือนก่อน

      @@danieldumitru2349 thanks

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

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

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

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

  • @user-dr2es2hk5j
    @user-dr2es2hk5j 6 หลายเดือนก่อน

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

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

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

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

    Thanks Kevin, very nice guide, noob friendly and concise

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

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

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

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

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

    really grateful as you uploaded the file

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

    What exactly I'm looking for! Thank you.

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

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

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

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

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

  • @KelebogileMabe-pp2qb
    @KelebogileMabe-pp2qb 10 หลายเดือนก่อน

    thank you so much this really helped not gonna lie.

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

    Great Job.. Thanks

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

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

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

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

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

    Thank you very much. I have learned something today.

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

    Thank you so much

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

    Thank you so much! Please upload more!

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

    This was really helpful!
    thank you sooo much

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

    Ty for easy explanation

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

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

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

  • @davebenner3276
    @davebenner3276 29 วันที่ผ่านมา

    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?

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

    Thanks for helping me with my math homework lol

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

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

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

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

    tysm wish you the best of luck my dude

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

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

    highly informative, thanks for sharing

  • @brendamartinezgomez2297
    @brendamartinezgomez2297 11 หลายเดือนก่อน

    Great video!

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

    Thanks Man!

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

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

    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

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

    Very helpful

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

    Awesome. Thanks 🙏

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

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

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

    How do you sort and input the data?

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

    Really helpful, thanks.

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

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

  • @user-vs3vs3rx7j
    @user-vs3vs3rx7j ปีที่แล้ว

    Wow i learnt alot

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

    Thank you very much!

  • @yogendrahirani1598
    @yogendrahirani1598 6 วันที่ผ่านมา

    wow! Great

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

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

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

    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

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

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

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

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

    Thank you! 📊✅

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

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

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

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

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

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

    good tutorial

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

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

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

    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?

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

    Thank youu

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

    Wow

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

    Bro just go to the point

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

    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

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

    interesing video.

  • @user-ed3gb5cd7v
    @user-ed3gb5cd7v 7 หลายเดือนก่อน

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

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

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

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

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

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

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

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

    Good video

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

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

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

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

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

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

    exelent

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

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

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

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

    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

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

    hello

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

    : D

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

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

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

    Thank you so much