how to make a pie chart in excel using select data

In the ' Format Data Series' window, select ' Secondary Axis' Right click on the pie chart, then click ' Format Data Series' Ģ. Step 10: Set second chart as Secondary Axis:ġ. In the ' Format Data Labels' window, select ' value', ' Show Leader Lines', and then ' Inside End' in the Label Position section Right click on the data label, click ' Format Data Labels' in the dialog box ģ.

Right click on the pie chart, click ' Add Data Labels' Ģ. Step 9: Add data labels in the NEW pie chart ġ. You should have a pie chart same as below In the ' Select Data Source' window, click move down button, the newly copied chart will move up at the same time, you will notice all labels disappeared ģ. Right click on the pie chart, click ' Select Data' Ģ. Step 8: Move up the newly pasted chart up ġ. This step will generate a second pie chart but you can not see any changes. Copy the first two columns data and paste on the pie chart (right click on anywhere in the plot area but not directly on the pies) Step 7: To create another chart exactly the same on top of this one. Step 6: To have the Leader Lines, drag each of the category names a bit far from the pie Step 5: Rotate Pie Chart: To rotate the pie chart, right click on the pie, select ' Format Data Series', adjust the ' Angle of first slice' to any degree you need (e.g., 64 degree, this number will be used later) Step 4: 'Category Name' and Position: Right click on any data label, and select ' Format Data Labels', in the dialog window, check ' Category Name', ' Show Leader Lines' and then check ' Outside End' in the Label Position section. The data labels were added to the pie chart. Step 3: Add Data Labels to the pie chart: right click on the pie, then click ' Add Data Label' Step 2: Delete Legend at the bottom (based on your setting, legend may appear in other position) Select first two columns of data, then in the Insert Tab from Ribbon, click Pie Chart. Step 1: To create a regular pie chart ( see here). The logic behind is to make two exactly same pie charts but with different labels.įor example, suppose we have the data below and we are going to make a chart with percentage labels inside and Names outside.

The Excel does not have a default function to add labels both inside and outside, however, with a few of tips, you can make your chart perfectly with labels in and out.

How to make a pie chart in excel using select data