Saturday, January 15, 2011

How to Make Labels With Excel 2007


1. Open the Microsoft Excel 2007 application on your computer and then click on the “Microsoft Office” button. Click on the “Open” option.
2. Locate the Excel document that includes the chart to which you want to add labels and then click on the “Open” button.
3. Click on the chart area to bring up the Chart Tools with the “Design,” “Layout” and “Format” tabs. Click on the “Layout” tab and then click on the “Data Labels” option from the “Labels” group.
4. Select the type of labels you want from the list. They will appear according to the type of graph or chart you have. Enter in the text you want for each label that corresponds with the chart.
5. Click on the “Format” tab and then click on the “Format Selection” option from the “Current Selection” group. Click on the “Label Options” button to change any label settings to meet your preferences. Click on the “OK” button to save your changes.
6. Edit any text in a label you’ve created by double-clicking on the label. Press the “Delete” key on your keyboard to remove text and then enter the new text you want to save. Click anywhere outside of the label and it will be saved on the chart.

Blogger news