Excel pie chart legend \change font size\ \excel for mac\
![excel pie chart legend \change font size\ \excel for mac\ excel pie chart legend \change font size\ \excel for mac\](https://contexturesblog.com/wp-content/uploads/2013/11/piechart05.png)
So we need to get the 2nd pie chart series rotated like we already did with the previous pie chart. Now you may have noticed that the pie chart and the leader lines don’t match up. Now you have created you’re a pie chart with both Outside and Center labels. Then you need to select the “Series 2” in the “Legend Entries (series)” area on the left and move it up to the top (the first series). So now to get our desired chart effect, and show two labels (one inside and one outside the pie chart, we need to do the following.įirst Right click on the pie chart and select “Select Data…” from the pop-up menu: So since your chart won’t look any different, you can see that your chart has a new series (series 2):
![excel pie chart legend \change font size\ \excel for mac\ excel pie chart legend \change font size\ \excel for mac\](https://scoreintl.org/wp-content/uploads/2018/07/DSC_7342-2-1024x682.jpg)
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.
![excel pie chart legend \change font size\ \excel for mac\ excel pie chart legend \change font size\ \excel for mac\](https://images.techhive.com/images/article/2016/01/06-insert-sunburst-100639990-orig.png)
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.