Page 199 - Excel Workbook for Dummies

20_798452 ch14.qxp 3/13/06 7:50 PM Page 182
182 Part III: Working with Graphics

14. On the Number tab, enter 0 in the Decimal Places.
15. On the Scale tab, make the following changes:
• 125000 in Maximum text box
• 25000 in Major Unit text box
• 5000 in Minor Unit text box
16. Select OK in the Format Axis dialog box and then click the Angle Counterclockwise
button at the end of the Chart toolbar.
17. Select the Plot Area on the Chart Objects drop-down list, click the Format Plot
Area button and then click the white color square in the Area section of the
Patterns tab before you select OK.
18. Check your formatted Clustered Bar chart against the one shown in Solved14-3.
xls in the Chapter 14 folder and then, if everything checks out, save your work
under the filename Solved14-3-mine.xls in the same folder. Close the Solved14-3.
xls workbook and leave the Solved14-3-mine.xls open for Exercise 14-4.

Editing Charts

Excel makes it easy to edit any chart you create. All you have to do is select the chart
before you click the Chart Wizard button on the Standard toolbar. If you’re editing an
embedded chart, you select it by clicking somewhere on the graphic object in the
worksheet. If you’re editing a chart on a separate chart sheet, you select it by clicking
its sheet tab.

After clicking the Chart Wizard button, Excel then opens the Chart Wizard – Step 1 of
4 – Chart Type dialog box. You can then use any of the options on the tabs of any of
the four Chart Wizard dialog box to make all necessary changes to the selected chart,
from selecting a new chart type and subtype all the way to changing its location from
worksheet to chart sheet and vice versa.

Try It

Exercise 14-4: Editing the Structure, Contents, and Location of a Chart

Use the Solved14-3-mine.xls workbook file with the embedded Clustered Bar chart you
formatted on its Sales-06 worksheet in the previous exercise to practice making edit-
ing changes to a finished chart:

1. Click your Clustered Bar chart to select it and then click the Copy button on the
Standard toolbar or press Ctrl+C to copy the graphic object to the Windows
Clipboard.
2. Scroll down to cell E38 in the Sales-06 worksheet and then click this cell to put
the cell cursor in it before you click the Paste button on the Standard toolbar or
press Ctrl+V.
Excel inserts a copy of the embedded Clustered Bar chart that covers roughly
the cell range A38:S60.
3. While the copy of the Clustered Bar chart is still selected, click the Chart Wizard
on the Standard toolbar to open the Chart Wizard – Step 1 of 4 – Chart Type
dialog box.