Working with Graphics and Charts

Advanced Training for Microsoft Office Excel 2003

Formatting and Resizing Graphics

1	To insert the logo of The Garden Company, click the Insert menu, point to Picture, and then click From File.
2	In the Insert Picture dialog box, click the Logo file, and then click Insert.
3	To begin formatting the picture, click the Format menu, and then click Picture.
4	To begin resizing the graphic by changing its Scale attributes, in the Format Picture dialog box, click the Size tab.
5	On the Size tab, in the Scale area, verify that the Lock aspect ratio check box is selected. To select the current Scale height value, in the Height box, double-click the number 100.
6	To change the Scale height and resize the graphic, for the purposes of this exercise, press SPACEBAR to have the number typed for you, and then click OK.
7	To resize the graphic manually, click on the lower-right handle of the graphic, and drag to the indicated area.
8	To begin rotating the graphic, click the Format menu, click Picture, and in the Format Picture dialog box, click the Size tab.
9	To select the current Rotation value, in the Size and rotate area, double-click in the Rotation box to select 0°, and then to rotate the graphic, press SPACEBAR to have the new number typed for you, and click OK.
10	To move the modified graphic, click the center of the graphic and drag to the indicated area.
11	To make more changes to the graphic, click the Format menu, and then click Picture.
12	To begin changing the graphic, in the Format Picture dialog box, verify that the Picture tab is selected, and in the Image control area, in the Brightness box, double-click the number 50 to select it.
13	To reduce the brightness of the graphic, press SPACEBAR to have the number typed for you.
14	To reduce the contrast of the graphic, in the Contrast box, double-click the number 50 to select it, and press SPACEBAR to have the number typed for you.
15	To crop a portion of the graphic, in the Crop from area, double-click in the Top box to select 0", and press SPACEBAR to have the number typed for you.
16	To apply your Format Picture changes, click OK.
17	To remove the crop, click the Format menu, click Picture, and on the Picture tab, double-click in the Top box to select 0.4", press SPACEBAR to have the number typed for you, and click OK.
18	To cut the graphic, on the Standard toolbar, click the Cut button, as indicated.
19	To create a background for your worksheet, click the Format menu, point to Sheet, click Background, and in the Sheet Background dialog box, click the Logo file, and click Insert.
20	To remove the background, click the Format menu, point to Sheet, and then click Delete Background.
21	To paste the graphic that was previously cut, click cell E6, and on the Standard toolbar, click the Paste button, as indicated.

Creating a Chart

1	To begin creating a chart based on the data in cells C1 through G13, drag from cell C1 to cell G13 and then, on the Standard toolbar, click the Chart Wizard button, as indicated.
2	Notice that the Clustered Column chart type is selected by default in the Chart Wizard. To create this type of chart, click Next.
3	To verify that the first row of the selected range defines the series for the chart, click the Series tab, and then click Next.
4	To give a title to the chart, click the Chart title box, then, for the purposes of this exercise, press SPACEBAR, wait as Monthly Sales is typed for you, and then press TAB.
5	To define the Category (X) axis label as Month, and the Value (Y) axis label as Sales, click Next.
6	To insert the chart in the active worksheet, click Finish.
7	To scroll to the bottom of the chart, drag the scroll box down to the bottom of the vertical scrollbar.
8	To reposition the chart below the worksheet data, point to the blank portion of the Chart Area to the left of the Month label, and drag it down to the indicated location.
9	To make the chart larger, hold the pointer over the lower-right corner of the Chart Area, and when a double-headed arrow appears, drag the corner down and to the right, to the lower-right corner of cell H33.
10	To begin formatting the chart, click the Format menu, and click Selected Chart Area.
11	To begin customizing the border of the chart, in the Format Chart Area dialog box, on the Patterns tab, in the Border section, click the Custom option.
12	To apply a thick, black border to the chart, in the Border section, click the Weight arrow, and then click the indicated border.
13	To add a shadow to a border, in the Border section, click the Shadow check box to insert a checkmark.
14	To begin modifying the fill effects, in the Area section, click Fill Effects.
15	To apply a texture to the chart, in the Fill Effects dialog box, click the Texture tab, and then, in the Texture section, click the indicated texture in the upper-left corner, and click OK.
16	To apply your formatting changes to the chart, in the Format Chart Area dialog box, click OK.

Creating a Dynamic Chart Using PivotCharts

1	To add a trendline to your sales data, click the Chart menu, and then click Add Trendline.
2	In the Add Trendline dialog box, notice the default options selected in the Type tab. To specify the forecast period, click the Options tab, and in the Forecast area, double-click in the Forward box to select 0.
3	To enter a new value, for the purposes of this exercise, press SPACEBAR to have the number typed for you, and click OK.
4	Notice that the trendline is created for the month of September. To close the SalesTrend workbook, click its Close button.
5	To save your changes, click Yes in the Microsoft Excel message box.
6	To create a PivotChart for your sales data, on the Standard toolbar, click the Open button, double-click the Sales folder, click HourlySales, and then click Open.
7	To create a PivotChart, click the PivotTable sheet tab, click cell L5, and on the PivotTable toolbar, click the Chart Wizard button, as indicated.
8	Notice that a new Chart1 sheet is created. To enter a new value for cell F6, click the Limited sheet tab, and press SPACEBAR to have the number typed for you.
9	To view the chart, click the Chart1 sheet tab.
10	To update the chart, on the PivotTable toolbar, click the Refresh Data button, as indicated.
11	Verify that the graph has changed as a result of the modified sales data. To begin creating a custom chart type, click the Chart menu and then click Chart Type.
12	To add the chart to the list of user-defined chart types, in the Chart Type dialog box, click the Custom Types tab, and in the Select from area, click User-defined, and then click Add.
13	To specify a name for the new chart, press SPACEBAR to have the text typed for you in the Name box of the Add Custom Chart Type dialog box.
14	To specify a description for the new chart, click in the Description box, press SPACEBAR to have the text typed for you, and then click OK.
15	To specify the new chart type, click the Standard Types tab, and in the Chart type area, click Area, and then click OK.
16	To save your changes, on the Standard toolbar, click the Save button.