Page 192 - Excel Workbook for Dummies

20_798452 ch14.qxp 3/13/06 7:49 PM Page 175
Chapter 14: Charting Spreadsheet Data 175
Eight sizing handles appear on the perimeter of a box drawn around the text in
the Chart Title, indicating that you can now move or resize the title in the Chart
Area. Also note that Chart Title now appears as the current selection in the Chart
Objects drop-down list box at the very beginning of the Chart toolbar.
4. Position the I-beam mouse pointer after the dash in the title and then click the
mouse to place the insertion point. Press the Backspace key to delete the dash
and then type for so that the Chart Title reads, Scheduled Production for 2006.

5. Click Legend on the Chart Objects drop-down list to select the Legend in the
chart.
Note that not only does Excel select the Legend (indicated by the appearance of
sizing handles around its perimeter), but at the same time deselects the Chart
Title and completes your edit to its text.
6. Position the mouse pointer somewhere inside the selected Legend and then drag
it upward until its top edge and the top edge of the Plot Area in the chart are
flush with one another.
7. Click Value Axis Title on the Chart Objects drop-down list to select the Units text
going up the left side of the chart and then click the Italic button on the Excel
Formatting toolbar.
8. Repeat this general procedure to italicize the Category Axis Title Month as well.
9. Make the following editing changes to entries in the designated cells noting the
change in the column of the chart representing the data point you’re changing:
• 353 in cell D4 containing the scheduled production of Part 101 for June 2006
• 560 in cell E4 containing the scheduled production of Part 101 for July 2006
• 675 in cell E6 containing the scheduled production of Part 103 for July 2006
10. Click anywhere on the embedded Clustered Column chart to select it and then
choose Chart➪Location on the pull-down menu to open the Chart Location
dialog box.
Note that the Chart menu only appears between the Tools and Window menus
on the Excel menu bar when you select the Chart Area of the embedded chart or
one of its other elements.
11. Select the As New Sheet option button and then replace the generic Chart1 name
in the associate text box with Sched-06 Chart before you select OK.
Excel inserts a new chart sheet named Sched-06 Chart as the first sheet in your
Exercise14-1.xls workbook containing the erstwhile embedded Clustered Column
chart.
12. Reposition the Sched-06 Chart sheet so that it is located immediately after the
Sched-06 worksheet in the workbook by dragging its sheet tab.
13. While the Sched-06 Chart sheet is still selected, click the Print Preview button on
the Standard toolbar.
Note that Excel automatically selects the landscape orientation for the chart and
prints it full size on the page.
14. Click the Close button on the Print Preview window’s toolbar to return to the
normal view of the Sched-06 Chart sheet.
15. Change the placement of the Clustered Column chart back to embedded and
then move the chart so that the top edge of the Chart Area is flush with the top
edge of row 9 and the left edge is flush with the left edge of column B.