Welcome toExcel2007.Tips.Net
Helpful Links
Cooking Tips
ExcelTips
Home Tips
Word2007 Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Add Data Labels to a Chart
Summary: Adding labels to a chart can make the information presented in the chart more understandable. Excel allows you to add different types of data labels to your charts, as discussed in this tip.Data labels are used to indicate what the main part of the chart represents. Depending on the type of chart you are creating, data labels can mean quite a bit. For instance, if you are formatting a pie chart, the data can be more difficult to understand if you don't include data labels.
To add data labels, follow these steps:
- Activate the chart by clicking on it, if necessary.
- Make sure the Layout tab of the ribbon is displayed.
- Click the Data Labels tool. Excel displays a number of options that control where your data labels are positioned.
- Select the position that best fits where you want your labels to appear.
Related Tips:
Take Control! Master the real power behind Word! Successfully master the secrets of powerful formatting and create documents that stand out from the rest. Best of all, you can create documents that are easy to maintain and quick to change. Check out Word 2007 Styles and Templates today!