Also, excel will only show one pie chart up front, so you are not sure which one you are seeing. You will now have a second series added to the pie chart, but you can’t see it because it looks exactly like the first pie chart your created. To do that, you need to do the following steps.Ī) Select and Copy your original chart data series A2:B6ī) Then right click on your pie chart and then select Paste: Okay, now you have created a nice chart, but it needs to have the percentages also appear in the center of each slice. After doing that on each slice, your chart should now look like this:
So on each one of the labels, select it once and then move it slightly to the left or right and you will then see the leader lines from the pie slice to the outside label appear. But to create the lines, you need to move the labels slightly. So to do that in Microsoft Excel, we are close because the labels are already on the outside of the pie chart. In the original USA Today chart, you see “Leader Lines” going to each of the “Outside Labels”. Then, from the “Format Data Series” dialog box, change the “Angle of first slice” to 350: To do this, right click on the chart and then select “Format Data Series” from the pop-up menu: So the Excel pie chart slice of “Interest Rates / Inflation Surge” spans from 11:30 (on the clock dial) to 3:15. Now the sample chart that we have is tilted slightly to the left.
0 kommentar(er)
