Excel: It All Adds Up Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Chart Tools ->Layout ->Data Labels

 

Format the Data Labels

What percent of the Retail Sales comes from the apples? The chart is formatted correctly, but the information is difficult to read.


4. Improve the Chart Layout
Click once on the chart to select it

Go to the Layout Ribbon

Click on Data Labels and

Select Outside End

 

The Data Labels are now outside of the pie chart. The chart is easier to read.