how do you make a pie chart in excel 2007

Click on the little right arrow that appears when you hover your mouse pointer over the Data Labels element.Ī list appears. You can show the data labels in percentage. Data labels are the values of the Apples Sales series for this case. Click on the Chart Elements icon, the list appears with three elements: I select “Data Labels”, data labels are added with the pie chart. You can explode a slice from the whole pie, just select a slice, and then drag the slice a little bit away from the main pie. For the next slice I select color aqua, for the next slice I select color Orange. I select Next slice, choose Olive green color, I select next slice, and select Purple color. And I select Red Accent 2 color for this slice. I select the Dark Blue Text 2 color for this slice. You can format the slice in your own way.

To select only a single slice, click again on the slice that you want to select. All the slices of the PIE chart are selected. You can choose any other style for your chart. A pie chart of the “Apple Sales” series is inserted into the worksheet.

2-D pie, 3-D pie, and Doughnut.Ģ-D pie has three categories: the first one is Regular Pie Chart, then Pie of Pie, and then Bar of Pie chart, 3-D pie, and Doughnut chart doesn’t have any category. Then click on the Insert tab, click on the Pie Chart drop-down, the drop-down list shows 3 sections. But you can create a pie chart using only Apple Sales Series or Orange Sales series or Mango Sales Series. So, this is not possible to create a pie chart using this whole data range. Apple Sales data series, Orange Sales data series, and Mango Sales data series. The data is about Apple, Orange, and Mango sales month-wise. In this worksheet, you see a range of data here. A pie chart with so many data points can be very difficult to interpret. Generally, a pie chart should not use more than 5 to 6 data points. Pie charts are most effective with a small number of data points. A pie chart is useful when you have only a series of data and you want to show the data in relative proportions of a value.

How do you make a pie chart in excel 2007