Formatting Chart Objects

1. To select a chart object to format, click on the chart object or select the object from the Chart Objects List and click the Format button.

2. A window will then appear containing the properties of that object. You can change these properties as you like.

• Chart Type: Click the arrowhead on the Chart Type button to select a different type of chart.
• Legend Toggle: Show or hide the Chart Legend by clicking this toggle button.
• Data Table view: Display the data table instead of the chart by clicking the Data Table toggle button.
• Display Data by Column or Row: Displays the data by columns or rows according to the data sheet.

An Overview of Formatting Charts and Cells

1. Formatting Chart Titles

1. Right-click the chart title, and choose Format Chart Title from the Format Chart Title dialog box.
2. Select the font settings, effects, and alignment you want.
3. Click OK.

2. Formatting Legends

1. Right-click the legend, and choose Format Legend from the Format Legend dialog box.
2. Select the font settings, effects, and alignment you want.
3. Click OK.

3. Changing the Background Color

1. Right click on the chart area (the white area), and choose Format Chart Area from the pop up menu.
2. Under the Pattern tab, select the color that you want.
3. You can also select Chart Area option from the Chart toolbar.

4. Formatting Axis Title

1. Right-click the axis title and choose Format Axis Title from the pop up menu.
2. Select the font settings, effects, and alignment you want from the Format Axis Title dialog box.

5. Adding Picture/ClipArt Image

You can add a picture or a clipart image to your chart or worksheet by:

1. Insert > Picture > ClipArt (To insert an image from ClipArt Gallery).

Or

2. Insert > Picture > From File (To insert an image stored in your local disk).

6. Rotating Text on Chart:

1. Click the text you want to rotate.
2. Click on the following buttons of the Chart toolbar:
   1. Rotate Text downward by 45 degrees.
   2. Rotate Text upward by 45 degrees.

7. Wrapping Text in Cells:

Youcan display a long line of text within a cell by wrapping the text.

1. Click the cell containing the text you want to wrap
2. Click Format > Cells > Alignment tab, and under the Text Control section check the option Wrap text, Click OK.

8. Printing the Chart:

You can print the chart with or without worksheet data:

1. If you highlight the chart with the worksheet data, and click File > Page Setup, you will get a dialog box with Page, Margins, Header/Footer, Sheet tabs.
2. If you highlight the chart without the worksheet data, and click File > Page Setup you will get a dialog box also with four tabs but with Page, Margins, Header/Footer and Chart tabs.