Page 198 - Excel Workbook for Dummies

20_798452 ch14.qxp 3/13/06 7:50 PM Page 181
Chapter 14: Charting Spreadsheet Data 181

2. Click the Chart Objects drop-down list button and then click Legend on its drop-
down menu. While the Legend is selected in the chart, click the Format Legend
button on the Chart toolbar to open the Format Legend dialog box.
Note that the Format button on the Chart toolbar is renamed with whatever
object is selected in the chart so that its ToolTip currently identifies it as the
Format Chart button.
3. Select the Shadow check box on the Patterns tab of the Format Legend dialog
box and then click the light yellow color square in the Area section on the right
side of this tab.

4. Click the Font tab, click 8 in the Size list box, and then select OK.
5. Select Chart Area on the Chart Objects drop-down list and then click the Format
Chart Area button to open the Format Chart Area dialog box.
6. Select the Shadow and Round Corners check boxes in the Border section and
then click the light green color square in the Area section.
7. Click the Properties tab and then select the Don’t Move or Size with Cells option
button before you select OK.
You need to select the Don’t Move or Size with Cells option to prevent Excel from
stretching and radically distorting the embedded Clustered Bar chart whenever
you redisplay the hidden columns in the worksheet.
To see how this works, take a moment to redisplay the hidden columns that con-
tain the underlying monthly sales totals and see how this affects the display of
the embedded chart in the worksheet. In this case, the columns were hidden by
using Excel’s Auto Outline feature (Data➪Group and Outline➪Auto Outline) and
then the outline buttons that you can use to control what level of detail is dis-
played both in terms of hidden columns and rows.
8. Click cell A1 to deselect the chart and then press Ctrl+8 to redisplay the outline
buttons to the left of the row headings and above the column headings.
9. Click the 3 button in the stack of vertical buttons immediately above the row 1
heading to redisplay the hidden columns with the monthly sales for each of the
four quarters.
Note that although the Clustered Bar chart does not move and is not resized, it
does change: Excel adds data points and bars for the newly displayed monthly
sales to the Clustered Bar chart.
10. Click the 2 button in the vertical stack and then Press Ctrl+8 again to hide the
monthly sales as well as the outline buttons; click the embedded Clustered Bar
chart to reselect it.

11. Using the Chart Objects drop-down button and associated Format buttons on the
Chart toolbar, make the following formatting changes:
• Chart Title — 10-point Arial bold type, enclosed in a light-yellow colored
text box with a drop shadow
• Value Axis Title — 9-point Arial bold
• Category Axis — 8-point Arial bold
12. Position the mouse pointer along the value axis along the bottom of Clustered
Bar chart. When the Value Axis ToolTip appears, click the axis to select it and
press Ctrl+1 to open the Format Axis dialog box.
13. On the Font tab of the Format Axis dialog box, select Bold in the Font Style list
box and 8 in the Size box.