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!
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.
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.
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!
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?
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
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 !!
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
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?
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.
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.
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!
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.
Thank you for being so thorough with this. Learned a lot!
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 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
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.
Very informative! I have to subscribe you're helping a lot thank you 🥰
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!
Great video! Thank you!
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?
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 add a column of corresponding color on the chart?
Is there a way to get the google sheets chart accurate within the 0.00 percentile?
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 !!
Very helpful thx
Is there a way to set up progress Pie charts?
Is there any way to create our own chart
Can you make pie of pie 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
Thank you for the video
Does Google Sheets have a Pie of Pie chart like Excel does?
No.
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?
Brilliant!
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
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.
Bro went through everything BUT bipolar chart
🙏🏻
whats with this comment section when was the internet so positive
lol