Once you’ve created a chart, you may wish to customize the various elements of your chart, depending on the chart layout you have chosen. Labeling a chart element inserts a small text box on or near the chart element. For instance, you may wish to display or reposition a chart title, axis titles, the chart legend or add data labels or the data table. To add or modify a chart element, click the contextual Layout tab under Chart Tools, click the button for the label you want to add or modify on the Labels area and then make your selection.
You can then format the actual text of the labels by clicking inside of the text box, drag selecting the existing text and then typing your changes.
To Add/Modify a Chart’s Labels
- Click the chart to select it.
- Click the contextual Layout tab under Chart Tools.
- Click the button for the label you want to modify on the Labels group.
- Select the option you want from the list.
To Change Chart Text
- Click on the Text Object you wish to edit.
- Click inside of the selected object and begin typing.
Similar Posts:
- Change the Layout and Style of a Chart in Excel 2007
- Creating a Pie Chart in Excel
- Change the Chart Type in Excel 2007
- Formatting Chart Elements in Excel 2007
- Formatting Chart Text in Excel 2007
- Modify an Organization Chart in Microsoft Office
- To Create a Chart in Excel 2007
