Thursday, October 24, 2013

How to Add Labels in Excel 2007


1. Open Microsoft Excel 2007 and the worksheet that contains the data you want to chart.
2. Select the data that will be charted and create a chart for it by clicking on the 'Insert' tab. Choose the type of chart you want to create from the 'Charts' group---column, line, pie, bar, area, scatter or other. Your chart will be placed onto the worksheet.
3. Make sure graph is selected, then click on the 'Layout' tab in the Ribbon, so you can add your data labels. Go to the 'Labels' group and click on the arrow by 'Data Labels.' Choose 'More Data Label Options' from the list of choices.
4. Select 'Label Options' in the 'Format Data Labels' dialog box.
5. Place a check mark by the options you want the data label to contain---'Series name,' 'Category Name' and/or 'Value' and remove any check marks you don't want.
6. Pick where you'd like the labels to appear---'Center,' 'Inside End' or 'Inside Base,' then click on 'Close.' The labels will be placed onto your chart.
7. Drag the labels manually on your chart if you'd prefer to place them in a different location.

Blogger news