|
Excel: Work Smarter
Data Labels identify the information in the
Chart. Here are some options.
Try This: Format the Data Labels
Select the Chart and go to Chart Tools.
Go to Layout->Data Labels.
Label Options: Select Category Name, and
Percentage. You can show the Leader Lines if you wish.
Label Position: Outside End.
What Do You See? The Data Labels should
display the Category Name (Alex, Connie, Niki) and the Percentage
outside of the Data point (the pie piece.) Chart Tools ->
Layout
-> Data Labels |
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 4. Presenting Data Visually
4.2. Modify charts 4.2.1. Add and remove chart elements: Percentages