How To Make Pie Chart In Google Sheets

0:00 Let's make a pie chart in Google Sheets. We have a bunch of lunch choices from the office here, and we want to see visually, what percentage of each one of these choices exists. So we need to get a little bit of data . We can't do it straight from this list. We'll do equals unique . We'll do B2 colon B, which is the range of choices, and we'll get all three choices here. We'll do a count if. Count if is going to also count in B To B. And the criterion will be just this D3 here. And now we will copy paste that. So now we see that McDo had five choices, Sweetgreen 11, KFC 4. This data here can be created into a pie chart . Just have to go to insert, chart . Now, it's going to suggest one. If it does not suggest pie chart immediately, go over to the chart type, Ultimate Checklist in Google Sheets The Simplest Bestest Checklist in Google Sheets Make an INTERACTIVE Pie Chart for PRIORITIES

0:46 click this arrow down, and scroll down and you'll see column, bar, then pie . So you have pie , donut, and also a 3D pie chart , which we can actually convert this to a 3D pie chart by selecting pie chart . But I want to make this a little bit nicer. Click over on customize. Our chart style , background color , we're going to hit none. Chart border color, none. We can maximize this or make it 3D if we want to make it look interesting. What I want to point your attention to is click on this pie chart and select slice label and just put label. And what this does is it takes the label from the side and puts it on the top of each of these sections. We can go back to chart style and click maximize and you can see here, we have a little bit of a legend here. So let's go down to legend and select none, keep it very clean. Build The Dashboard - Design a Better Dashboard Part 3 Make an INTERACTIVE Pie Chart for PRIORITIES

1:33 We can go to chart title and accesses if we want to edit any of these, if we add a title here. We can also change the color of each of these pie slices. Let's change mcdough to red, select sweet green and change it to. Green, and we'll select KFC and switch it to dark brown. Well, that looks terrible. Dark orange. There. So, we have a pretty cool little pie chart here that has labels on it. This shows us visually how many people selected each one without giving us the exact number . It just shows sweet green, way more than half, right? That's how to make a pie chart in Google Sheets . If you want to get more out of your Google Sheets than you ever have before, consider subscribing here on YouTube to BetterSheets. DarkSide of Google Sheets - Creating Dark Mode and Making it Better! Make It Easier For Others To Use Your Google Sheets Make an INTERACTIVE Pie Chart for PRIORITIES