Formatting Chart Elements

graphics/microsoft37.gif

Objects such as annotated text, data labels, and titles are referred to as chart text . To make chart text more readable, you can change the text font, style, and size. You might decide to increase your chart title, or change the labels of your x- and y-axis. You can also change the format of a chart axis . For example, if axis labels or scales are too long and unreadable, you might want to reduce the font size or change the scale to make the labels fit better in a small space.

Format Chart Text

graphics/one_icon.jpg

Select the chart that contains the text you want to change.

graphics/tow_icon.jpg

Double-click the object that contains the text.

graphics/three_icon.jpg

Click the Font tab.

graphics/foure_icon.jpg

Select a font, font style, and then the size you want.

graphics/five_icon.jpg

Select any combination of the Underline, Color, or Background options.

graphics/six_icon.jpg

Select any combination of the Effects options.

graphics/seven_icon.jpg

Select the Auto Scale option if you want the text to be scaled in order to fit.

graphics/eight_icon.jpg

Click OK.

graphics/09inf35.jpg

graphics/09inf36.jpg

Format a Chart Axis

graphics/one_icon.jpg

Select the chart that contains the axis you want to change.

graphics/tow_icon.jpg

Double-click the axis you want to format.

graphics/three_icon.jpg

Click the Scale tab.

graphics/foure_icon.jpg

Select the scale and display units you want.

graphics/five_icon.jpg

If you need to change the number format, click the Number tab.

graphics/six_icon.jpg

Click OK.

graphics/09inf37.jpg

graphics/09inf38.jpg

Did You Know?

You can change chart text alignment . Double-click the text you want to change, click the Alignment tab, change the orientation, and then click OK.

You can change chart axis patterns . Double-click the axis you want to change, click the Patterns tab, change the line style, major or minor tick mark type, and labels, and then click OK.



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