how to make a pie chart in excel with categorical data

In this case, we got lucky and it knew we wanted a pie chart.

The above steps would make Google Sheets use some assumptions and try to guess what type of chart you want to insert. It’s important that during your clicking you don’t accidentally click an empty cell because it will un-select the data you want to make a chart of.

With the data selected, navigate to the top bar, and click on the Insert option in the menu.Select the cells for which you want to create the pie chart.Go to the Google Sheets that has the data (of course).Without further ado, here’s our guide for creating a pie chart in Google Sheets: You’ll notice this is a two-column pie chart, and your data might look similar, but it can be done with any data in the cells. Our pie chart is going to show what chunk of our monthly budget goes to different categories such as food costs, rent, and student loan payments.īelow is the dataset that we will be using to create a pie chart: In this example, we’re going to make a mock budget and compare the costs. Keep in mind that a pie chart is used to compare things within the same larger category. Then we’ll look at some additional steps you can take, and some cool customization that you can do too!

We’re going to look at step-by-step directions for how to how to do a pie chart in Google Sheets. How Do I Make a Pie Chart in Google Sheets in 2022? How Do You Make a Pie Chart in Google Sheets on iPhone and Android?.How Do You Make a Double Pie Chart in Google Sheets?.How to Make a Pie Chart in Google Sheets Look Better.How Do I Make a Pie Chart in Google Sheets in 2022?.

How to make a pie chart in excel with categorical data