The first column contains a country name, and the second column contains the population percentage. I have a top ten country population percentage over the world population.
Up next: Insert a linked Excel pie chart.You can download this Pie Chart Excel Template here – Pie Chart Excel Template Example #1 – 2D Pie Chart in Excel
Let’s close the pane and click Slide Show to see how the chart looks. Now, the piece with the pie detail has special formatting. In the pane, I’ll click Effects, SHADOW, Presets and choose a shadowed preset, such as Inside Center. I’ll click on the pie to select all the pieces, then I’ll double-click the Otherpiece to select just that piece, and open the Format Data Point pane. Last, I’ll add an effect to just one piece, the one labeled Other. I’ll click the Chart Styles icon and look for a style with white text, seeing a preview when I point to a thumbnail. I need to make the labels easier to see, though. In the Pie of Pie Chart, the three smallest pieces have been pulled out and enlarged, and their combined percentage shows in the main pie. Then, from the types available, I’ll click this one, Pie of Pie, and click OK.
Here’s what I mean: I’ll right-click the chart and click Change Series Chart Type. Now, another thing I could do with the smallest pie sections is pull them out, like a detail. It rotates the pieces to the right and moves the labels away from the title. I’ll right-click the chart, and click Format Data Series.įor the angle of the first slice, I’ll click the up arrow and change the angle from 0 degrees to 80 degrees. To fix that, I can rotate the pie slices.
I like the labels, though the ones at the top are crowded under the title. So, in the pane, I’ll check Category Name.Ī name and percentage now show in the data label. I’d also like to show the Salesperson’s name. In the labels, the dollar amounts are replaced with percentages. So, I’ll click Undo, go back to LABEL OPTIONS, check Percentage, and uncheck Value. On second thought, I like the idea of showing percentages. That adds the dollar symbol and decimal places to the label. Under Category, I’ll click the arrow and choose Currency. To add a dollar symbol to these values, I can scroll down in the pane and click NUMBER. Right now, Value is selected, so the labels show the dollar values I entered, when I created the chart. Under LABEL OPTIONS, I select what I want the label to show. I’ll click More Options to see what those are. Here’s Center, Inside End - which appears to be the default - Outside End, Best Fit, and Data Callout, which includes the Salesperson’s name and shows a percentage instead of a dollar amount. Then, I’ll click the arrow next to Data Labels and point to other options for label position.
Let’s check the Data Labels box to display the labels. The Data Labels preview on the chart, showing an Order Amount in each section. I’ll click the top one, Chart Elements, and in CHART ELEMENTS, point to Data Labels. Now let’s customize the chart, so it has the details and style we want.įirst, to show the value of each pie section, we’ll add data labels to the pieces.