Enhancing a Chart

Add chart objects , such as titles, legends, and text annotations to a chart to enhance its appearance and increase its overall effectiveness. A chart title identifies the primary purpose of the chart; a title for each axis further clarifies the data that is plotted. Titles can be more than one line and can be formatted just like other worksheet text. You can also add a text annotation , additional text not attached to a specific axis or data point, to call attention to a trend or some other area of interest. A legend helps the reader connect the colors and patterns in a chart with the data they represent.

Add a Title

graphics/one_icon.jpg

Select a chart to which you want to add a title or titles.

graphics/tow_icon.jpg

Click the Chart menu, and then click Chart Options.

graphics/three_icon.jpg

Click the Titles tab.

graphics/foure_icon.jpg

Type the text you want for the title of the chart.

graphics/five_icon.jpg

To add a title for the x-axis, press Tab, and then type the text.

graphics/six_icon.jpg

To add a title for the y-axis, press Tab, and then type the text.

graphics/seven_icon.jpg

If you want a second line for the x- or y-axis, press Tab to move to the Second Category or Second Value box, and then type the title text.

graphics/eight_icon.jpg

Preview the title(s) you are adding.

graphics/nine_icon.jpg

Click OK.

graphics/09inf27.jpg

graphics/09inf28.jpg

Did You Know?

You can resize the text box to create a multiple-line title . Select the text box, and then drag a resize handle. Click in the text, and then type in the text box.

Add or Delete a Legend

graphics/one_icon.jpg

Select the chart to which you want to add or delete a legend.

graphics/tow_icon.jpg

Click the Legend button on the Chart toolbar. You can drag the legend to move it to a new location.

graphics/09inf29.jpg

Add a Text Annotation

graphics/one_icon.jpg

Select a chart to which you want to add a text annotation.

graphics/tow_icon.jpg

Type the text for the annotation, and then press Enter. A text box containing your text appears within the chart area.

graphics/three_icon.jpg

Position the mouse pointer over the text box until the pointer changes shape.

graphics/foure_icon.jpg

Drag the selected text box to a new location.

graphics/five_icon.jpg

Press Esc to deselect the text box.

graphics/09inf30.jpg

Did You Know?

You can customize your legend . Legend text is derived from the data series plotted within a chart. You can rename an item within a legend by changing the text in the data series.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net