Google Sheets - Pie Chart Comprehensive Tutorial
Вставка
- Опубліковано 26 лип 2024
- In this video learn how to make pie charts in Google Sheets. This tutorial also covers how to show labels, values, percentage, change data range, change colors, make dynamic filters and more.
Two years later still doing justice! Just used this video to help me make a pie chart I can use to cycle through my portfolio sectors to show percentages of stonks!
Thank you for being so thorough with this. Learned a lot!
Another excellent video. I like how you break down a complicated topic then build it up step by step. Great, too, when you say the command shortcuts you use to navigate the spreadsheets. Soon, they become so much more handy than using the mouse alone. Thanx.
Great Instructional. The extra steps for making a drop down menu to update pie chart and also how to aggregate data! All great! Thank you.
Great video! Thank you!
Very informative! I have to subscribe you're helping a lot thank you 🥰
Brilliant!
You did a really good job of making something complicated simple to understand! You have a new subscriber. 😊
Welcome aboard Roger!
@@ExcelGoogleSheets 4yrs later and Same! Thank you!
Thank you for the video
Thank you so much for the videos. How would you add functionality to the last section where you created a drop down to include "all regions"?
very detailed but also about 2 millions steps...COME ON MAAAAN
Very helpful thx
Great tutorial. I'm stuck in something, though. I have a pie chart with only 2 items (Wins and Losses). In the chart, it shows the slice Losses on the LEFT side, and the slice Wins on the RIGHT side even though the table is the opposite (Wins - LEFT | Losses - RIGHT). How do I flip that in the chart? Thanks!
Hi good vídeo !
Is there any Way to filter pie graphic to display sizes in order from lower to bigger size só that itS easier to see which slice is bigger / smaller ?? Thanks !!
Is it possible to create an aggregate data column from a column of percentages and narrow them down into groups? e.g. 0-25%, 26-50%, 51-75%, 76-100% as aggregated groups from a column of many rows of single percentages?
I think the answer is no. In this pie chart example, is it possible to change the percentage font color? This is the color of the number percentage under each line - I know I can change the label, but can I change the autogenerated font color. At 9:14 example, upper left corner - PUMA 9.7% - the 9.7% is in a grey font. Can the 9.7% be customized? These tutorials are the best.
Is there a way to add a column of corresponding color on the chart?
Is there a way to set up progress Pie charts?
will the last part still work if I use data validation for certain items in the data?
I tried it but an error appears and the data i tried to build wont show
🙏🏻
Is there a way to get the google sheets chart accurate within the 0.00 percentile?
Can you make pie of pie chart?
Is there any way to create our own chart
How can I get multiple categories drill down? On this video you drill down by brand, but imagine like 3 or 4 sub categories like:
STATE
CITY
BRAND
MODEL...etc
WHAT IF DATA AND LABELS ARE IN ROWS
Looks like Google Sheets is not mature enough to make pivot charts without preprocessing the data. Though the explanation is very clear, thanks for that!
We need to have the option to do one or the other. I don't keep raw sheets with that data on it, so I needed it done that way. I'm designing a Bullet Journal spread with the most amount of data in the smallest space, not a raw sheet full of numbers.
can you please upload your files, typing in the data is driving me crazy, its 2 clicks for you and 15 minutes of typing for me, help us out here
One week ago, I could start with/be inside of the space I wanted the pie chart in and then Goog would generate a sheet with a range of data for me to change the numbers and labels in. Today (July 14, 2019) that option is gone.
What happened?
I got a pop-up tutorial for how to use the new method, but after I clicked "next", it disappeared and I am still uninformed about how to create the chart.
This video is not showing me how to begin inside the space I want the chart in.
...
...
...
...
...
...
Why does the Universe hate me?
There's been a change in my google sheets as well. Now when I change a colour of one sector in the series menu, it changes all the other sectors' colours according to it, so I can't have a custom coloured chart... Do you know, if there was an update, or something? It really sucks...
@@matejcvancara5256 I don't know what happened. But I when I follow his instructions now, I don't get the same user interface. As soon as I enter my labels, it wants to know if I want to "combine ranges" horizontally or vertically. wtf?
What I really want is to insert a little pie chart on my sheet in a merged group of cells next to the data.
Why can't I do this?
Does Google Sheets have a Pie of Pie chart like Excel does?
No.
Bro went through everything BUT bipolar chart
At 11:56 "and finally" Why did you skip the Inside option, it's literally the only reason why I watched this video and you decide to skip it. Frustration is unreal.
You might be looking for Pie Chart->Slice Label. Inside option is disabled for pies.
whats with this comment section when was the internet so positive
lol