how do you make a pie chart in excel 2007

You should keep in mind that, you can only create Pie Charts for a single column or row of data. I hope that you thoroughly understood the methods I showed in this tutorial to make a Pie Chart in Excel without numbers. Read More: How to Create a Pie Chart in Excel from Pivot Table (2 Quick Ways) Finally, the last operation will convert the pivot chart into a Pie Chart.After that, in the Change Chart Type window select Pie and press OK.Then, from the options menu select Change Series Chart Type.Next, right-click on any of the bars on the pivot chart.Now, you will see a pivot chart on the worksheet.Here, check the Answer option and drag the Answer option to the Values section.Then, on the right, a new PivotChart Fields window opens.After that, click on an empty cell in column E and press OK.Now, in the new Create PivotChart window, select the option Existing Worksheet.Below this, click on the PivotChart option.

Second, go to the Insert tab and select the PivotChart dropdown.First, select the dataset from cells B4 to C10.Let us jump right into this final method. We are using the same data set from the first method to keep things simple. We can easily create a Pie Chart for data without numbers using Pivot Charts. Make Pie Chart in Excel Using Pivot Chart How to Make Pie Chart with Breakout in Excel (Step by Step)Ģ.Explode Pie Chart in Excel (2 Easy Methods).How to Group Small Values in Excel Pie Chart (2 Suitable Examples).Make Multiple Pie Charts from One Table (3 Easy Ways).How to Make a Budget Pie Chart in Excel (with Easy Steps).Read More: How to Make a Pie Chart with Multiple Data in Excel (2 Ways) As a result, Excel will generate a Pie Chart showing the proportions of the answers.There, click on the Insert Pie Chart drop-down and select 2-D Pie.Then, select the table from cell E4 to F7 and go to the Insert tab above.Now, press Enter and copy the formula to the cells below using the Fill Handle.Note that, you can also type the formula directly into the formula bar.

How do you make a pie chart in excel 2007