Creating a Pie Chart in Google Sheets

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ส.ค. 2024
  • Learn how to create a pie chart using Google Sheets. To download the file used in this video, visit the following page: www.vertex42.c...
    0:21 When Pie Charts are useful (and when not)
    1:09 How to set up the data table for a Pie Chart
    1:45 Make a Pie Chart using the Explore feature or Insert Chart
    2:32 Customize your Pie Chart
    Don't Forget to Subscribe! 😃
    UPDATES: (2:17) Google sheets uses 3 dots "•••" instead of "More" to get to the other icons that aren't displaying. (2:21) The Chart Editor window has a new look and organization (with the "Data" tab changed to "Setup") but it's still similar enough to follow instructions. (3:44) When customizing a pie chart, go to "Pie Slices" instead of "Series."
    FOLLOW VERTEX42 HERE:
    Instagram: / vertex42
    Facebook: / vertex42
    Pinterest: / vertex42
    Twitter: / vertex42
    LOOKING FOR SPREADSHEET TEMPLATES? Start Here:
    www.vertex42.com/

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

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

    Thank you for helping me in my quest to be a spreadsheet ninja.

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

    This has to be the finest instructive video for Sheets pie chart.

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

      You could’ve just said it was helpful lol

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

    really helped my on my school project i was so lost at first

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

    U have no idea how much you helped me

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

    Thanks so much
    Super helpful for my school project.

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

      same here

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

    I just wanna know how to do it even though I never will.

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

    Thank you very much! Very educational video, it helped me to understand everything so quickly!

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

    I like how you didn't show how to manually do this, you just showed a shortcut instead of actually doing what the video title says you will be doing. Please rename this video accordingly so others are not wasting their time on this like I did.
    Thanks!

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

    EDIT: figured it out, but now I have a different issue. I have sorted my data according to the highest %. However, the pie slices are in seemingly random order. How do I order the pie slices? I can't find the option anywhere.

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

    the vid starts at 1:11

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

    epic vid now i can teach epicly!!!

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

    Thank you soooo much this was so helpful!!!

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

    Thanks this really help me a lot.

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

    Thank you! This was very helpful!

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

    Thank you, this helped me a lot.

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

    Thank you, very helpful.

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

    Wonderful vid! Thank you!

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

    also helpful for my school, thank you

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

    THANK THE LORD FOR THIS VIDEO AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

  • @JSark-by2ts
    @JSark-by2ts 2 ปีที่แล้ว +1

    Well done - thank you for the tutorial Vertex42!

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

    What do you do if your data isn’t a percent

    • @Human-tj6fv
      @Human-tj6fv 2 ปีที่แล้ว

      2:12 is a helpful time stamp... click that it doesn't need to be percent for it to work google auto fills

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

    no clue why you skipped over the part of selecting the data from the sheet which has multiple columns

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

    a pie chart from expoler suggestion - I love it! thx

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

    actual video begins at 1:10 .

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

    tutorial starts at 1:10

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

    Please put bookmarks. First 80s is explaining what pie chart is and why is not necessarily what you are looking for...

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

    Thanks. This was very clear and helpful.

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

    sweet tutorial thanks a lot

  • @LarcenAn
    @LarcenAn 11 หลายเดือนก่อน +1

    can you rotate the pie?
    like how?

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

    how do u create a pattern fill on pie chart google sheet tho? it shows on the original ms. ppt but it won't show on google sheet

  • @harefieldscraftcider256
    @harefieldscraftcider256 6 ปีที่แล้ว +35

    The title of your video is "Creating a Pie Chart in Google Sheets" but it is 2m15s before you start explaing how to do this, that's 50% waffle. This instruction/ video could be be 30secs long.
    8:26
    Google Sheets- Sort and Filters
    Mike Kanfer
    52K views
    4:28
    Making a Line Graph using GoogleSheets
    MrsChampagne25
    8.8K views
    1:59
    How to Create a Pie Chart with Google Sheets
    Pamela Shoemaker
    20K views
    5:01
    Vlookup in Google Sheets
    Patrick Donovan
    2.1K views
    12:36
    Google Sheets - Dashboard
    SyncSisters
    25K views
    8:10
    Google Sheets VLOOKUP from another Spreadsheet with IMPORTRANGE Tutorial - Part 7
    Learn Google Spreadsheets
    15K views
    3:11
    How to Make a Line Graph from Google Sheets
    KnightBio1
    37K views
    6:10
    Creating a Column Chart with Google Sheets
    Tim Thompson
    3.9K views
    11:04
    Google Sheets - Combine Data From Multiple Sheets (Tabs) Tutorial
    Learn Google Spreadsheets
    29K views
    3:25
    Calculating Percent in Google Sheets
    Project IDEA
    8.9K views
    26:24
    Google Sheets 2016 Tutorial
    SyncSisters
    148K views
    3:41
    How to create a progress chart in Google Sheets
    Richard Byrne
    27K views
    18:42
    Google Data Studio Tutorial - Create Dashboards Like a Pro
    Loves Data
    Recommended for you
    27:44
    Top 25 Excel 2016 Tips and Tricks
    Sele Training
    Recommended for you
    6:15
    Making a Simple Bar Graph in Google Sheets 12/2017
    Maria Boulmetis
    2.7K views
    5:18
    Making a Multi-Line Line Graph in Google Sheets
    Maria Boulmetis
    80K views

    • @MrVirkMedia
      @MrVirkMedia 4 ปีที่แล้ว +6

      its good to have waffle to help those people that are new to the concept

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

    How do you round off the percentage on a chart?

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

    For some reason my label isn’t showing up on the pie chart any suggestions?

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

    Thank you, this helped a ton!

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

    How do you change the size of the pie slices?!

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

    Thank you

  • @mohameddekar2278
    @mohameddekar2278 8 หลายเดือนก่อน +6

    anyone in 2023

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

    Is there a way to customize the color of the line and percentage stretching outside of the pie chart? Both the line and the percent value seems to be automatically set according to the background, i.e. for white background they'll display as grey. I can't find a way to change font and color of those. On "Legend" only the label font and color can be edited.

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

    the voice is vey low eventhough volume on 100

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

    I have my volume maxed out on everything & I'm still struggling to hear what she's saying. Might want to redo the audio & increase the volume.

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

    thanks. now i can make pac-man

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

      Lil Snikrz 😜😂😂😂😂😂🤯

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

      hahahahah im dead 😂😂😂😭

  • @jaxustay
    @jaxustay 15 วันที่ผ่านมา +1

    Anyone in 2024

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

    How do i make the background transparent?

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

      Click on your chart >> Customize >> Chart Style >> Background color >> None

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

    OIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII NAS COSTA

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

    Not me at 10:34 making a pie chart-

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

    Thank u

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

    thanks lad

  • @gracie7559
    @gracie7559 4 ปีที่แล้ว +6

    the tutorial starts at 1:09
    Your welcome

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

      Thanks. I modified the description to say 1:09 instead of 1:10.

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

    You have got to be kidding me with this video. Are you sure you don't want to go over the origin of the pie?

  • @mumblesemcee
    @mumblesemcee 6 ปีที่แล้ว

    THANK YOU!

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

    your video is too quiet. I wish I could actually hear what you're saying

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

    awesome

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

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

    👍🏼

  • @No-jh1xr
    @No-jh1xr 5 ปีที่แล้ว +2

    this strait up doesnt work though

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

    Adding or formatting labels is not correct.

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

    thanku bb

  • @DarkMoonDroid
    @DarkMoonDroid 5 ปีที่แล้ว

    This is outdated.
    G-Sheets have been changed and now I don't know how to use charts all over again as if I was a newb. >:-(