Task 3 Adding Titles and Labels

Objective To add a title and axes labels to the graph.

Instructions You will use the Titles command from the Insert menu.

Comment Charts, like numbers, will be meaningless unless there is information on what the chart is about and what the elements of the chart are supposed to represent.

Activity 3.2 Click in the square check boxes alongside the items Chart Title, Value (Y) Axis and Category (X) Axis. Click <OK>.

You will be returned to the chart worksheet, only there will now be three titles on it.

Activity 3.3 Click on the text Title at the top of the graph. It should appear surrounded by a grey border and little black squares. The word title should also appear in the cell reference section of the formula bar. If you just start typing now the text you type in the formula bar will replace the text on the sheet. Type the following title: "Graph of Sales per Region for Each Sales Rep". What you type will appear in the formula bar as you type it. When you click elsewhere on the graph or press <Enter> the title will take on the text you have just typed in.

Activity 3.4 Now click on the X-Axis label at the bottom of the graph. Now instead of just starting to type, notice that the mouse cursor changes to an I-Beam text editing cursor as you pass it across the X. Click on the right side of the X, and you will notice the blinking text cursor that signifies you are editing text. Press the backspace key once to delete the X, and then type "Sales Reps". When you have finished click on any other part of the graph.

Activity 3.5 This time select the Y-Axis label along the side of the graph. Notice that the text, "Y", is rotated 90 degrees alongside the Y axis. If you start typing the text will be replaced by what you are typing. However, click on the Y again, just like you did for the X-axis. The Y swivels round and appears in the proper orientation with a blinking I-Beam cursor alongside it. Delete the Y and type the following text: "Sales in Thousands". When you have finished click anywhere outside the editing area. The text appears alongside the Y axis, rotated 90 degrees.

OSU | CoF | Community | Search | Forestry Computing Helpdesk