There are a few ways to make a pie chart in Excel. The easiest way is to use the pie chart icon in the insert ribbon. Click on the icon, select the data range, and Excel will create the chart for you.
If you want more control over the chart, you can use the pie chart formula. The formula takes a little more effort to set up, but it gives you more flexibility over the look and feel of your chart.
To create a pie chart using the formula, you first need to create a table of data like this:
Then, you use the following formula to create the chart:
This formula tells Excel to create a pie chart using the data in the B2:B7 and C2:C7 cells.