Formatting Chart Text
Making charts more attractive, you can format chart items by borders around the titles, the legend, and the text boxes. Then you can also change the color, thickness, and style of the border, and choose the color of the area within the border. Procedures: select the Chart sheet. Right-click on the chart title. Choose Format Chart Title. Under Border, select Custom. From the style drop-down list, select Dotted. From the Color drop-down list, select Red. From the Weight drop-down list, select Thickest. Click on Ok. Click off the chart to deselect it. In the Format dialog box, the Font tab contains the information for the default chart font. On this tab, you can change the font’s type, style, size, and color. You can also specify that the font be underlined with single or double lines, use an effect such as subscript or superscript, and have a transparent or opaque background.
When you modify the default font, any chart text that uses the default font settings is updated to reflect your changes. Procedure: double-click on the white chart background. The Format Chart Area dialog box is displayed with the Patterns tab selected. Select the Font tab. In the Font list box, select a Font. In the Size list box, select a size. From the Color drop-down list, select a color and Click on OK.
You can change the font of individual chart text items by either double-clicking on the chart item or choosing Format, Selected, and then changing the font settings on the Font tab. The same font formatting options are available for individual chart items as are available for changing the default chart font. You can also format individual characters by selecting them and applying font changes. However, if the chart text is linked to worksheet data, you will not be able to apply formatting to individual characters in the text, because you must first be able to select the text in order to format it. Double-click on the chart title, then the Format Chart Title dialog box will display. You can also format the category axis by double-clicking on it.
You can use the Alignment tab in the Format dialog box to change the alignment of chart text from the horizontal default. You can change the orientation of chart text by rotating it. You can specify the amount of text rotation either by entering a number in the Degree text box or by dragging the text. When you drag the text, the degree of rotation is reflected in the Degree text box. When you enter a positive number or drag upward, the text is rotated from the lower left to the upper right.
Formatting Labels.
A chart appearance can be improved by changing the format and alignment of chart items and chart text. You can apply different number formats, such as currency, percent, or decimal, to the numbers on chart by using the options available in the Format dialog box. Double-click on the value axis. (The Format Axis dialog box will display) select the Number tab. Under Category, select Currency. Click on OK.
Applying the same formatting to the data labels. Right-click on the indicated data label. Choose Format Data Labels. In the Category list box, select Currency.
Data labels alignment also can be change the way the text is being changed by double-clicking on the data labels to display the Format Data Labels dialog box, select the Alignment tab, and specify the orientation in degrees. E.g. select the Alignment tab. Change the value in the Degree text box to --. Display the Label Position drop-down list. Select Center. Click on OK. To enhance the appearance of a chart, you can apply different colors and patterns to the data markers for each series. You might find it useful to format data markers with patterns when you are printing to non-color printers, or when you are printing charts that you plan to use as overheads. To display the Format Data Series dialog box, you double-click on one of the markers in the series. You can apply formatting to the individual data markers within a series, but if you do, that data marker will not match the legend or the other markers in the series. In the dialog box, under Area, click on Fill Effects. In the dialog box, select the Pattern tab. Under Pattern, select the upper-left pattern. Select a foreground color and a background color. Click on OK, click on OK.
Regards,
BEM T. CELESTINE
Social Plugin