![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |