How to Make a Pie Chart in Excel

Creating a Chart

1. Select all of your data. To do so, click the A1 cell, hold down ⇧ Shift, and then click the bottom value in the B column. This will select all of your data.

   1. If your chart uses different column letters, numbers, and so on, simply remember to click the top-left cell in your data group and then click the bottom-right while holding ⇧ Shift.

2. Click the Insert tab. It's at the top of the Excel window, just right of the Home tab.

3. Click the "Pie Chart" icon. This is a circular button in the "Charts" group of options, which is below and to the right of the Insert tab. You'll see several options appear in a drop-down menu:

   1. 2-D Pie - Create a simple pie chart that displays color-coded sections of your data.
   2. 3-D Pie - Uses a three-dimensional pie chart that displays color-coded data.

4. Click an option. Doing so will create a pie chart with your data applied to it; you should see color-coded tabs at the bottom of the chart that correspond to the colored sections of the chart itself.

   1. You can preview options here by hovering your mouse over the different chart templates.

5. Customize your chart's appearance. To do so, click the Design tab near the top of the "Excel" window, then click on an option in the "Chart Styles" group. This will change the way your graph looks, including the color schemes used, the text allocation, and whether or not percentages are displayed.

   1. To view the Design tab, your chart must be selected. You can select a chart by clicking it.